The "replace" function is exist in version 7.30.
"Art S. Kagel" wrote:
> No. You could do it using a brute force approach in a stored procedure
> but it will be a dog in performance. Better to make that script a 4GL
> or ESQL/C program and fix up the string in code. Or better yet break
> that into to columns for surname and first name and you can then:
>
> SELECT trim(surname) || ', ' || trim(first_name), ....
>
> Art S. Kagel
>
> Sven Heins wrote:
> >
> > Is there anything like the above string functions in Informix?
> >
> > I would like to do something like this...
> >
> > select replace( name, "/", ", ") from table1
> > where ...
> >
> > If there is a string "Smith/Thomas" in the column 'name' the result should
> > be "Smith, Thomas".
> > Is informix able to do so???
> >
> > Thanks for your help.
> >
> > --
> > Sven Heins
> > solution42 IT systems & consulting Gmbh & Co KG
> > http://www.solution42.de