Re: Case Sensitivity - Oracle 7/ODBC Sql calls

Try: SELECT * FROM TABLE WHERE UPPER(NAME) = UPPER('John');

no_at_spam.allowed wrote in message ...
>Is there a way to execute an sql script against a table which is NOT case
>sensitive? For example, in my table's a name might be stored as John.
>How can I execute a script looking for a matching column without being
>exactly case correct; i.e. SELECT * from {table} where NAME = 'john';
>(instead of: ... where NAME = 'John';)
>
>You're help is most appreciated. If possible, please respond via e-mail.
>
>--
>Robert H. Lieberman
>rhl_at_automate.net
>
Received on Tue Mar 10 1998 - 00:00:00 CET