Hi All,
I have a SELECT query with WHERE-IN clause (string values are present in the
where-in clause)
I need this query to be case insensitive.
I checked with simply WHERE clause and in it, the query can be made
case-insensitive by adding COLLATE NOCASE, but this does not seem to work
with WHERE-IN.
Am I missing something??
For eg, If my table contains two values viz, 'Arjabh' and 'abc'
I want my query "SELECT name FROM table WHERE name IN ('arjabh','ABC')", to
return both the values.
Thanks and Regards,
Arjabh
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
