Oracle query with LOWER

Posted by Nickolodeon on Stack Overflow See other posts from Stack Overflow or by Nickolodeon
Published on 2011-01-13T17:02:24Z Indexed on 2011/01/13 17:53 UTC
Read the original article Hit count: 125

Filed under:
|

Hi. Why this returns 0 rows

SELECT GARTUSERID, USER_CODE, UNITID, RANKCODE, RANKID, FIO, LOGINNAME, 
       START_DATE, EXPIR_DATE, NOTE, POSITION, ISCHGPASSWORD, IS_EXPIRDATE,
       IS_BLOCKED, ROW_ID
  FROM ACONTROL.GARTUSERS
 WHERE LOWER(LOGINNAME)=LOWER(:LOGIN) AND ROW_ID=:MD5PSWD

and this returns 1 row (as I wanted for the first query)?

SELECT GARTUSERID, USER_CODE, UNITID, RANKCODE, RANKID, FIO, LOGINNAME,
       START_DATE, EXPIR_DATE, NOTE, POSITION, ISCHGPASSWORD, IS_EXPIRDATE,
       IS_BLOCKED, ROW_ID 
  FROM ACONTROL.GARTUSERS
 WHERE LOGINNAME=:LOGIN AND ROW_ID=:MD5PSWD

© Stack Overflow or respective owner

Related posts about sql

Related posts about Oracle