Previous Topic

Next Topic

Book Contents

Book Index

Examples

Assume INFO is a variable that contains the string TESTDATA.

Table 198 INFO Function Examples

Function

Returns value:

REPLACE(INFO,'A','F')

TESTDFTA

REPLACE(INFO,'A','B',2)

TESTDATB

REPLACE(INFO,'A','B',1,2)

TESTDBTB

REPLACE(INFO,'A','FF',1,3)

TESTDFFTFF

REPLACE(INFO,'DATA','XXXXX')

TESTXXXXX

Parent Topic

REPLACE: Functions