Hi, I'm trying to execute the following select statement in Oracle 8i. SELECT EMPNO,LOWER(EMPNAME) FROM EMPLOYEE WHERE EMPNAME LIKE ? What actually happens here ? My understanding was that EMPNAME column values are first lower-cased, and then SELECT statement is executed. If I have EMPNAME column value as 'Mallika', and I pass 'mallika' to the above query, I expected the column value to be 'mallika' in the database temporarily. But I'm not getting the row containing 'Mallika'. If I pass 'Mallika', I get the row. So, is the execution of the query in the following order ? 1. First query is executed and rows are obtained. 2. Next, EMPNAME column values are converted into lowercase and then shown. Have I interpreted in correctly ? Any clarifications will be helpful. Thanks.
Joined: Mar 13, 2001
you almost had it. You set the return values to lower. If you want to do it during the compare, you use the lower in the where clause ex : select empname, empno from emp where lower(empname) like 'mi%' Dan [This message has been edited by Daniel Dunleavy (edited June 05, 2001).]