Of cause, that works but it was not what i realy want. Is there a way to prevent 
upper/lower case in the field and create only the key case insensitive. I know 
other DBM's where i can create a key insensitive:

CREATE INDEX Foo on Bar (fld CASE)


> 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. . .).
 
---
[EMAIL PROTECTED]
http://www.net-connection.de
http://www.tradenet32.de

Reply via email to