REPLACE#

Functionality:#

This Oracle function will remove characters from within a string.

Parameters: #

STRING The source, or original, string
SEARCH The character string that you want to replace
REPLACE (optional) The characters that you want to take the place of the characters specified in SEARCH above. If not specified, it will remove the characters specified in SEARCH

Returns: #

Text

Errors: #

None

Example:#

replace(~,'-') will remove all hyphens from the passed string

replace(~,'-','.') will change all hyphens to periods in the passed string.


Notes #

Click to create a new notes page