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