Hi!
On Mon, 12 Apr 1999, Mike Barnes wrote:
> Hiho ... I'd really like to know if anyone has any good suggestions for
> performing case insensitive searches on data in a 6.3 server using Perl. If
> there's some really obvious solution I'm missing, please club me over the
> head with it.
Make all things lowercase:
SELECT * FROM mytable WHERE lower(mycolumn) = 'mylowercasedata'
For regexp searching use ~* (case insensitive regexp).
> Mike.
>
>
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
