Re: [SQL] Searching Text Fields - Case Sensitive?

> Mike Field wrote:
> Hi-
> If I want to search a text field for a certain word, say 'foobar',
> using:
> SELECT * FROM mydb WHERE description LIKE "%foobar%";
> it seems to be case sensitive.  Is there a way to do it so it is NOT
> case-sensitive?
SELECT * FROM mydb WHERE lower(description) LIKE "%foobar%";

bart
-- 
bart@bart.w-wa.pl || http://www.bart.w-wa.pl