Searching by some like case

select * from tab where tname like 'EMP%'; <--- must big case !!!