SQL & PL/SQL

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!

LIKE case insensitivity

538129Dec 11 2007 — edited Dec 11 2007

I am attempting to do a query using the LIKE keyword however I want to match all cases i.e. make the query case-insensitive. How can I achieve this please? Currently this will only match the exact case specified.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2008

Added on Dec 11 2007

13 comments

54,412 views