I wanted to normalize text entered by users so that I could collect stats. So I SQL’d something like this… select count(1) as total, upper(nvl(resp,’NO RESPONSE’)) as resp from forms.form_field_resp where ffid=#id# group by upper(nvl(resp,’NO RESPONSE’)) order by total desc But I didn’t want to display the text in all CAPS BECAUSE THAT’S PRETTY DANG ANNOYING. So I rigged this to set the very first character to upper case and then replace every character after […]