[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Syntax for non case sensitive string search - wild card

Posted on 2006-05-05
Medium Priority
Last Modified: 2008-02-01
Please advise,

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.
Question by:Schrodenger
1 Comment
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 500 total points
ID: 16615049
sqlStr = "SELECT * FROM myTable where UPPER(myField) LIKE '%"& UCASE(userInput) &"%'"

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question