Re: Sensitive SQL Question

Tony Holder writes: >I read in an earlier thread that you can turn off case sensitivity in >a CONSTRUCT with "OPTIONS CONSTRUCT CASE INSENSITIVE" but the >compiler just moans with a "-4373 A grammatical, blah blah blah ..." error, I >checked the Informix manuals and there was no reference to it, Is it >the version of RDS i am running?, There must be a way around this >without retreiving every row from the table and then UPSHIFTing it >before comparing!, Could stored procedures do it? There is no OPTIONS CONSTRUCT CASE INSENSITIVE. I was only responding that IMHO it would be *nice* if there was such a statement. Regards, Mike Teachworth CodeGen Software, Inc 800-598-8649 504-456-1260 fax work email: mike@codegen.com