[RBASE-L] - Re: Case Insensitive ODBC/Oterro Queries

[Alan Steward]

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