Re: Anything like REPLACE or SUBSTITUTE?

Oh d**n, I have got to start including 7.3x features in my thought patterns. I am misleading folk more and more on this lately. Thanks for the correction. Art Wu wrote: > > 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