use the '~*' operator, i.e., "attribute" ~* 'pattern'
Ragnar
-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Robert Kernell
Sent: Tuesday, October 03, 2000 17:41
To: pgsql-general@postgresql.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@sundog.larc.nasa.gov