Re: Anything like REPLACE or SUBSTITUTE?

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