On Fri, 28 Sep 2001, Tomasz Misterka wrote: > Hello, > > I've got a problem with finding how to search database with string without > checking if string is "Chris" or "chris". > > Now when I'm searching database for word "chris" i can't find word > "Chris" - how the SELECT should looks like?
Something like select ... where lower(column) = 'chris' should do what you want. If you want to use indexes you'll need to make an index on lower(column) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
