Re: Case Sensitivity - Oracle 7/ODBC Sql calls

no_at_spam.allowed wrote:
>
> 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
>
SELECT * from {table} where UPPER(NAME) = 'JOHN' Received on Tue Mar 10 1998 - 00:00:00 CET