Skip to Main Content
Forums

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!

SELECT Query to get the Values in Case insensitive Format

harikumarmplSep 15 2008 — edited Sep 15 2008
Hi ,

This is hari,

I want to select the user name in a table ex: username="HARI" or username='Hari' or username="HaRi" like this

If i wrote the query like

select username from userdb where username="Hari";

it is displaying the records which only matches "Hari" only .

can anybody help me out on this query asap please....


the query should return all the results

which matches any of the following strings as inputs "HARI" or "HaRi" or "hAri" or the like.

Awaiting for Response,

Thanks & Regards

Hari
This post has been answered by Nicolas Gasparotto on Sep 15 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2008
Added on Sep 15 2008
#search
12 comments
536 views