Is there any function like REPLACE?

Question

Is there any function to replace words in ASE?

Answer 1

Try this:

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