Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comparing Uppercase record with lowercase query

386736Jan 30 2003 — edited Jan 31 2003

Hi, im working off of a database with all uppercase values currently and im attempting to do a like clause to pull out of the database something "like" the value I'm using to query. For example, if the lastname is SMITH, and I enter Smi%, I want to pull SMITH out of the database without having to enter a capital SMI%. Whats the best way for me to do this comparison?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2003

Added on Jan 30 2003

#general-database-discussions

5 comments

310 views