Re: [sqlite] How to specify collating sequences in an expression.

[Derrell . Lipman]

[EMAIL PROTECTED] writes:

>   (4)  What syntax do you prefer?

This seems the clearest to me, of the given choices:

     SELECT * FROM t1 WHERE CAST(x AS TEXT COLLATE NOCASE)='HELLO';

Derrell

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------