Re: Case-Insensitive search
This is new in 7.3:
select * from mytable where upper(mycol1) = 'TEST';
or try in any Informix Version:
select * from mytable where mycol1 matches '[Tt][Ee][Ss][Tt]';
Andreas Zeugswetter
iftikhar_khan@mailcity.com wrote:
> Hi Everybody
>
> Can we make a case insensitive search in Informix? Example when I say SELECT
> * FROM mytable WHERE mycol1 = "TEST" It makes case sensitive match of mycol1
> with "TEST" and brings the matching records. But I want all records with any
> word test like "TEST", "test", "TEst" etc.
>
> Thanks in advance.
> Regards,
> Iftikhar
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading