SQL Syntax for non case sensitive string search - wild card
Posted on 2006-05-05
I have an input box on an asp page where I want to take the value entered and search an Oracle database field , find instances of the input and return the associated record .
Thus far I have been successfull to the point that I can retrieve records only if the case of the input matches the string in the field.
sqlStr = "SELECT * FROM myTable where myField LIKE '%"& userInput &"%'"
is there a UCase() or strtoupper() that I can add in the SQL string like :
sqlStr = "SELECT * FROM myTable where UCASE(myField) LIKE '%"& UCASE(userInput) &"%'"
Thanks for your help.