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
Printable View
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
Yes Rajeev,
Got it.
Thanks a deal.
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