sandr

Search and replace text.

sandr(search, replace, text)

Returns the text expression with the search REX expression replaced with the replace expression. See the REX documentation and the Vortex sandr function documentation for complete syntax of the search and replace expressions.

SELECT  NAME, sandr('>>=SYS=', 'SYSTEM TABLE ', NAME) DESCRIPTION
     FROM    SYSTABLES

The results are:

NAME                DESCRIPTION
 SYSTABLES            SYSTEM TABLE TABLES
 SYSCOLUMNS           SYSTEM TABLE COLUMNS
 SYSINDEX             SYSTEM TABLE INDEX
 SYSUSERS             SYSTEM TABLE USERS
 SYSPERMS             SYSTEM TABLE PERMS
 SYSTRIG              SYSTEM TABLE TRIG
 SYSMETAINDEX         SYSTEM TABLE METAINDEX

Added in version 3.0