Thank you. I'm sure this has been addressed before, but I couldn't remember where the list archive was. You'd think as long as I've been on this list I'd have known the answer to this anyway :)
-- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: [EMAIL PROTECTED] > [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] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
