How to write Select query with ignore case

[H. J. Yoshi]

hi,
i need to retrieve data from an Oracle 9i db.One of the columns has data differing only in case(upper/lower).Please help regarding the query to obtain the same..

Thanks

[Srinivasa Raghavan]

Use the lower() function.

SELECT * From emp where LOWER(ename) = 'java'

Oracle String functions should help you.

[sachin K Kansal]

hi Himadri,

You can use either lower or upper function on both sides of the where condition

eg: select * from emp where upper(job)= upper('dba');

if you use at either side of where clause it may not retrieve proper results