Equals Ignore case query

[gsreenathreddy]

Hi All,

Is there any query in Oracle that will ignore the case with DB. I know there function in JAVA which ignore the case. Is there any feature same available in oracle.

For Example: I have ename in DB as "aBc" and in search query user is entering as "ABC". I need to get the details of ename="aBc". How can we achieve this?

Thanks,
Sreenath

[Rabbit]

Use the LCASE or LOWER function on both sides of the equivalency.

[samir pradhan]

SELECT Ename FROM Db
WHERE UPPER(Ename)='A BC';