Is there any function like REPLACE?

Question

Is there any function to replace words in ASE?

Answer 1

Try the following:

SELECT str_replace( 'impossible', 'im',':)' ) 

Answer 2

 select str_replace(original,search,replacement) 

ASE does not have "REPLACE", but "str_replace". This will return varchar (LONG), you may have use cast to reduce it.

Answer 3

REPLACE (source string, search string, replacement string)

 SELECT REPLACE( 'abc,def,ghi,jkl', 'abc', 'xx' ) FROM products