Re: Are Informix deaf, dumb, and blind?

> :>May be Informix don't do anything about this right now because it will > :>be available in the Universal Server coming out soon. (Assuming > :>Informix or someone else implement a datablade with this > :>functionallity - but they better do that). You don't actually need a special datablade to do this. I have Illustra up&running and there you have UPPER and LOWER functions. There is a nice feature in addition: You can create a index on the output of the function: CREATE INDEX x1 USING BTREE ON mytab(UPPER(column)); (Syntax might beincorrect). Then queries like select * from mytab where upper(column)="KJHKJH" would use the index which is much nicer than sequential scans. Bless, -- Snorri Bergmann | Mail: snorri@strengur.is Strengur Consulting Engineers | WWW: http://www.strengur.is/ Armuli 7 | Phone: +354 550 9000 (9007 direct) 108 Reykjavik Iceland | Telefax: +354 550 9010