Progress
SQL-92
Guide and Reference
REPLACE Function
Replaces all occurrences of string_exp2 in string_exp1 with string_exp3.
SYNTAX
EXAMPLE
This example illustrates the REPLACE function, replacing the letters ’mi’ in the last_name ’Smith’ with the letters ’moo’:
NOTES
string_exp
can be fixed-length or variable-length CHARACTER data types.- If any of the arguments of the expression evaluates to null, the result is null.
- If the replacement string is not found in the search string, it returns the original string.
- Each occurrence of
string_exp
and the result may contain multi-byte characters. Character comparisons are case-sensitive and are determined by sort weights in the collation table in the database.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |