lower OR upper case...search form &

[shervell]

re: non case senstive search throgh html form querying oracle database - quite a few folks have given me code or ideas could for 2 search boxes for upper & the other for lower case data but is there a way to have one submission & query the database on both lower & upper case & return the results?

cheers

g

[requestcode]

I believe that you are going to have to do this on the Server Side rather than the Client side. You will need to convert the data in the database to either Upper Case or Lower Case or both to make it effective. This probably would involve pulling the data into a temporary variable and performing the Upper/Lower Case conversion then comparing it to the search value.