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) DESC
     FROM    SYSTABLES

The results are:

NAME DESC 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