Radi,
Case sensitivity is controlled by the RBase command "SET CASE ON/OFF".
OFF means that commands are case insensitive. You can query the current value "SET VAR STCASE = (CVAL('CASE'))"
SHOW VAR STCASE will give you the value.
I beliver that the default value for CASE is OFF.
I only know how to do this from native RBase. Someone else on the list can help you on how to accomplish this from OTERRO. I remember that there was discussions on this list on ohow to do this.
Jim Bentley
American Celiac Society
Alan Steward <[EMAIL PROTECTED]> wrote:
Case sensitivity is controlled by the RBase command "SET CASE ON/OFF".
OFF means that commands are case insensitive. You can query the current value "SET VAR STCASE = (CVAL('CASE'))"
SHOW VAR STCASE will give you the value.
I beliver that the default value for CASE is OFF.
I only know how to do this from native RBase. Someone else on the list can help you on how to accomplish this from OTERRO. I remember that there was discussions on this list on ohow to do this.
Jim Bentley
American Celiac Society
Alan Steward <[EMAIL PROTECTED]> wrote:
Radi,
I don't have exact RBase SQL and function syntax available to me
right now, but here's the Oracle SQL construct I would use to handle
upper/lower/mixed case qualification:
SELECT * FROM users WHERE UPPER (user) = 'JDOE'
or
SELECT * FROM users WHERE LOWER (user) = 'jdoe'
Alan Steward
At 08:59 01/30/2006 -0800, you wrote:
>I need to find a way to query an RBase database via ODBC/Oterro that
>is case insensitive. i.e. evaluates SELECT * FROM users WHERE user
>= 'jdoe' would select records with either jdoe or Jdoe as the value.
>
>Any help is appreciated!
>
>Thanks!
>
>
>Radi
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.
