Re: SELECT question

That did it. Thanks.

Devrim GUNDUZ wrote:

>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>

--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!