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@postgresql.org)
 

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