How to write Select query with ignore case (Oracle/OAS ...

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 ... MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified.

www.coderanch.com