Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Case-INSENSITIVE searches?? Possible??
How can I perform a case-insensitive search?
I trying to perform a search on any portion of a description field that can be entered in Mixed case. My SQL statement is using the LIKE '%search%' statement, but it won't return matches that don't have the same case.
Any ideas? Received on Wed Mar 28 2001 - 13:08:30 CST