Hi,
On Fri, 2003-01-31 at 01:11, Brian Avis wrote:
> I want to run a SELECT on a text field and match any of the following.
>
> brian
> Brian
> BRIAN
>
> Or any other combination. How do I tell SQL to ignore case when doing
> a SELECT?
SELECT * FROM table WHERE column ILIKE 'brian%';
should work.
Best regards,
--
Devrim GUNDUZ
www.gunduz.org
