How to replace string with another string in sybase?

str_replace

Description

Replaces any instances of the second string expression (string_expression2) that occur within the first string expression (string_expression1) with a third expression (string_expression3).

Syntax

replace(string_expression1, string_expression2, string_expression3)

Parameters

string_expression1

is the source string, or the string expression to be searched, expressed as char, varchar, unichar, univarchar, varbinary, or binary datatype.

string_expression2

is the pattern string, or the string expression to find within the first expression (string_expression1). string_expression2 is expressed as char, varchar, unichar, univarchar, varbinary, or binary datatype.

string_expression3

is the replacement string expression, expressed as char, varchar, unichar, univarchar, binary,...