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.
Daniel Dunleavy
Ranch Hand
Joined: Mar 13, 2001
Posts: 276
posted
0
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).]
0
