How do you UCase a column in SQL in ASP. I allow people to search for a word in a text field. I tried converting the input field to all upper case and then pass the variable to the SQL statement. Did this OK. Then I tried to UCase the field but I kept on getting UCase is not a recognized function. I can get it to work no problem in Access, but I cannot when working within ASP. What am I doing wrong?