Re: [sqlite] Case Insensitive Equality Searches

[drh]

[EMAIL PROTECTED] wrote:
> If I want to do "SELECT * FROM table WHERE field = value",
> how can I do this matching text only and not case?
> 

   SELECT * FROM table
    WHERE field COLLATE nocase = value;

--
D. Richard Hipp  <[EMAIL PROTECTED]>


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