VistaDB 5
REPLACE
REPLACE ( string_expression , string_pattern , string_replacement )

string_expression
Is the string expression to be searched. string_expression can be of a character or binary data type.

string_pattern
Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string ('').

string_replacement
Is the replacement string. string_replacement can be of a character or binary data type.

See Also