use the '~*' operator, i.e., "attribute" ~* 'pattern'
Ragnar
-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Robert Kernell
Sent: Tuesday, October 03, 2000 17:41
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] case insensitive matching
Hi. LIKE does case sensitive string matching. Is there an easy way to do
case
insensitive string matching?
Bob Kernell
Research Scientist
AS&M
email: kernell(at)sundog(dot)larc(dot)nasa(dot)gov