Convert data values to upper case before insert
solvetekJul 22 2009 — edited Jul 27 2009I have a text field in a form where users can enter data in upper or lower case. I would like the data be inserted in upper case. How do I convert to upper case? I know in SQL I can use upper(col1). I am not sure where I would put this command of if there is a better method.