Hi All,
I found it myself.
For WHERE IN clause, COLLATE NOCASE should be after column name (previously,
i tried it by placing it after the expression)
eg, SELECT name FROM table WHERE name COLLATE NOCASE IN ('arjabh','ABC')
Thanks and Regards,
Arjabh
On Wed, Aug 3, 2011 at 11:30 AM, arjabh say <arjabh...@gmail.com> wrote:
> 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
