On Thu, 3 Sep 1998, David Hartwig wrote:
> > First question: is there a way to do this that is NOT case sensitive?>
> Use the case insensitive regular expression operator.
> select * from rolodex where name ~* '.*$name.*'
Thanks! that solved both my problems.
Is this regular SQL or something more specific to PostgreSQL ?
The SQL book I looked through didn't show anything like this ~*
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------