Skip to Content
0
Former Member
Apr 23, 2007 at 08:56 AM

mssql case sensitivity

126 Views

mssql is case sensitive..

while selecting...i got problem...

SELECT * FROM YEMM_OUTMAIL INNER JOIN YEMM_OUTMAIL_ACK ON YEMM_OUTMAIL.EMAILID = YEMM_OUTMAIL_ACK.EMAILID WHERE YEMM_OUTMAIL.TIMEIN>=1177257600937 AND LOWER(YEMM_OUTMAIL_ACK.RECEIPIENT)='johnson@yahoo.com'

i can run in sql analyzer..but not in my coding...

what goes wrong

Intermediate-SQL syntax error: UPPER or LOWER function not allowed

#

so the collection return to node is blank...

i cannot see anything in my table