Case Sensitivity - Oracle 7/ODBC Sql calls
From: <no_at_spam.allowed>
Date: 1998/03/10
Message-ID: <MPG.f6f3d72e088a02d9896f8_at_news.wwa.com>#1/1
Date: 1998/03/10
Message-ID: <MPG.f6f3d72e088a02d9896f8_at_news.wwa.com>#1/1
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