of memory from what I've heard on the list but I'm
sure someone is working on it..
-Mitch
- Original Message -
From: Joern Muehlencord <[EMAIL PROTECTED]>
To: gpsql-sql <[EMAIL PROTECTED]>
Sent: Monday, June 26, 2000 2:14 PM
Subject: [SQL] case insensitive searc
Joern,
select myfield from tablea where lower(myfield) = 'mysearch';
or
select myfield from tablea where myfield ~* 'mysearch';
Troy
>
> Hello together,
>
> how can I handle case insensitive search in a table?
>
>
>
> --
> Linux is like wigwam - no windows, no gates, apache inside.
> In
Hello together,
how can I handle case insensitive search in a table?
--
Linux is like wigwam - no windows, no gates, apache inside.
In diesem Sinne
Joern
