Kalesha Shaik

 Profile Answers by Kalesha Shaik 

• May 3rd, 2011

 

select * from emp where ename like '%r%' or ename like '%R';

RAM3MOHAN

 Profile Answers by RAM3MOHAN 

• Jun 18th, 2011

 

select * from student where name like '%r%' or name like '%R%'

Aviral Chhabra

 Profile Answers by Aviral Chhabra 

• Jul 12th, 2011

 

select * from emp where ename like '%r%' or ename like '%R%';

Sanjay Bajracharya

• Jul 13th, 2011

 

Code
SELECT * FROM emp WHERE upper(ename) LIKE '%R%';