Re: Anything like REPLACE or SUBSTITUTE?

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