Retrieve the detail from emp

[Geek_Guest]

Question asked by visitor siddharth

Retrieve the detail from emp table with help of ename
where ename may be in any case like (SCOTT,ScoTT, scott,scOtt)

[Barbie]

select * from emp where lower(ename)='scott'

This will do it.

[reetasharma108]

Hi,
either of following:-

select * from emp where lower(ename) like '%scott%';
or

select * from emp where upper(ename) like '%SCOTT%';

Reeta

[Innila]

Hi,

Using Case Manipulation functions (Upper, Lower, Initcap) will be more appropriate for this validation.

[debasisdas]

if u are sure the loist contains 'scott' in any case then go for

select * from emp where lower(ename)='scott'

else try to use like search