Re: select on string_length - x don't work, please help!

Fasi wrote: > > I always get: > Major error code: -201 > [VENDORLIB] Vendor Library Error: A syntax error has occurred. > > i use Informix Universal-Server version 9.1, is the SUBSTRING function > avalible in this version, because i don't find it the tutorial. > or do i have to write the SUBSTRING function first? No, I think it was a 7.30 feature, which means you probably won't see it until version 9.20. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+