RE: Sensitive SQL Question
the "OPTIONS CONSTRUCT CASE INSENSITIVE" statement was only wishful
thinking, not a real statement.
-joe-
(huddles@hasting.com)
----------
From: ilist
To: informix-list
Subject: Sensitive SQL Question
Date: Wednesday, February 22, 1995 11:40AM
Is there any way to turn of case sensitivity for a simple query e.g.
select * from clients where cliname matches "PHUCKIT*"
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?
I am running
RDS 4.10
Online 5.03
----------------------------------------------------------------------------
Tony Holder
RDL UK LTD Email:
Tony@robinsuk.demon.co.uk
1 - 3 Sun Street Voice: 0171 638 9481
London, EC2A 2BJ Fax: 0171 628 3383