Re: Urgent

tommi@epgmbh.de wrote: > Jonathan Leffler <jleffler@earthlink.net> writes: > > l_nadella@yahoo.com wrote: > >> I am a newbie to Informix 7.2 but familiar with Oracle. Is there > >> an equivalent for SUBSTR function in Informix? I need to trim the > >> first four characters from the values stored in a column. Also I > >> need to convert any character which is not alphanumeric(/:, etc.) > >> to a hyphen. Any Ideas??? > > > > Not in 7.2; you need 7.3 to get the Oracle-style functions. > > You can do 'select textcolun[1,4] from table' to get the first four > characters. True, but the object of the exercise was to get characters 5 to the end, and there isn't a convenient way of encoding that with subscripts. It also, unfortunately, does not address the non-alphanumeric conversion. I wonder what is supposed to happen to spaces and newlines? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>