SQL Reference

REPLACE

>>-REPLACE--(--expression1--,--expression2--,--expression3--)--><
 

The schema is SYSFUN.

Replaces all occurrences of expression2 in expression1 with expression3.

The first argument can be of any built-in character string or binary string type. For a VARCHAR the maximum length is 4 000 bytes and for a CLOB or a binary string the maximum length is 1 048 576 bytes. CHAR is converted to VARCHAR and LONG VARCHAR is converted to CLOB(1M). The second and third arguments are identical to the first argument.

The result of the function is:

The result can be null; if any argument is null, the result is the null value.

Example:


[ Top of Page | Previous Page | Next Page ]