Ignore case in SQL select

[rsuri]

Hemant,
you have to use only one combination with Upper or Lower.

select name from name_table
where UPPER(name) = ' KRISHNA';

will return ALL the rows --

name
-----------
Krishna
KRishna
KRishnA
kRiSHNa
KriSHNA
KRISHNa
KRISHNA
KriShNa

- Rajeev

[hemanr]

Yes Rajeev,
Got it.

Thanks a deal.

[rmgirma]

the following will return all the values you specified.

select ename from emp where lower(ename) like 'krishn%';

If you want this statement to use an index, you have to create a function based index.

Robel