I know this is an oracle group, but I only monitor some oracle groups.
My problem is that I have to write embedded SQL code which has to work
both under Oracle and Informix (using #ifdef INFORMIX is OK).
I want to create case independent queries. With Oracle I can use
select * from tab where to_upper(col) = 'XYZ'; I cannot find something
like this in the Informix manuals (Version 7).
Of course I could resort to another colunm which contains the same
information in upper case. This probably is faster than using to_upper
at runtime.
Thanks in advance for any help.
Received on Sat Sep 26 1998 - 08:57:40 CDT
