|
|
|
|
|
|
|
|
|
|
version 11
REPLACE (arithmetic_expression, arithmetic_expression, arithmetic_expression)
Description
The REPLACE function looks in the first arithmetic_expression passed for all the occurrences of the second arithmetic_expression passed and replaces each one found with the third arithmetic_expression passed. If no such occurrences are found, the first arithmetic_expression remains unchanged.
Example
This example will replace the word "Francs" by "Euro":
SELECT Name, REPLACE(Currency, 'Francs', 'Euro') FROM PRODUCTS;
See Also
|
|
|
|
|
|
|
|
|
|