Is there any function like REPLACE?

Question

Is there any function to replace words in ASE?

Got the ans..str_replace is working – SSE Jul 01 '11 at 11:35 — SSE, Jul 01 '11 at 11:35

score 9 · Answer 1 · edited Oct 06 '11 at 12:35

9

Try this:

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

edited Oct 06 '11 at 12:35

Jason Plank

answered Sep 30 '11 at 02:13

deepak

score 1 · Answer 2 · answered Dec 12 '13 at 19:23

1

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 shrink it back down.

answered Dec 12 '13 at 19:23

nka

score 0 · Answer 3 · answered Jul 01 '11 at 11:39

0

REPLACE ( original-string, search-string, replace-string )

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

answered Jul 01 '11 at 11:39

sudheshna

What is the output you are getting and how do you want to replace the words, from which field in the table etc. please detail – sudheshna Jul 05 '11 at 06:14
REPLACE is a sybase IQ function and will not work for Sybase ASE – Beginner Mar 31 '17 at 12:43

3 Answers3