SQL Non Case sensitivity

From: George Zolla <gazolla_at_nps.navy.mil>
Date: 1996/08/13
Message-ID: <3210FF34.30F0_at_nps.navy.mil>#1/1

I am designing and implementing a webserver to Oracle cgi. I let the user query the Oracle table using a standard html form. The query works fine if the client uses first letter upper and all the rest lower case. My problem is that I would like to let the user put in the last name without worrying about whether the name has any capital letters. The field is first upper and the rest lower case. (Smith). I would like the user to just put in smith. I am now using "like" so I can use the wildcard: "%"

I know there is a command to make all letters upper or lower case, but I would like to use the fields as it is. I don't want to set up an array and count the number of characters in the string.

Interbase uses the word 'containing" to do this. I have searched through my manuals but can't find a way to do this. It appears there isn't a standatrd SQL word, is there an Oracle word for this?

I would really appreciate someone's help!

---

George Zolla
E-mail: gazolla_at_nps.navy.mil Received on Tue Aug 13 1996 - 00:00:00 CEST