convert BOTH the user-input AND the field you are comparing to the SAME
CASE within the sql statement. then the user doesn't have to worry about
which case he/she uses (nor does the sysadmin. . .).
select * from userdata where lower(name) = lower('john');
or replace lower('john') with lower(userinputvariablename)
jt
-----Original Message-----
From: Armin Diehl [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 13, 2000 4:15 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Case insensitive
Hi,
of cause that works, but what if we need a case incensitive primary key,
the
example ist very slow if you have a lot of records. Is that possible ?
> > select * from userdata wher name = 'John'
> >
> > select * from userdata wher name = 'joHN'
> >
> > will fetch me the same results.
>
> select * from userdata where lower(name) = 'john'
---
[EMAIL PROTECTED]
http://www.net-connection.de
http://www.tradenet32.de
