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@postgresql.org)
--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
Have a nice diurnal anomaly!