4D v13.4

REPLACE

Home

 
4D v13.4
REPLACE

REPLACE  


 

 

Command REPLACEREPLACE (arithmetic_expression, arithmetic_expression, arithmetic_expression)

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;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

TRANSLATE