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: 128
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