meta data for this page
  •  

F_CONVERTSYMBOLS

input/output-compatibility to rFunc (CONVERTSYMBOLS, LONGCONVERTSYMBOLS)

Entrypoint convertsymbols not compatible with UTF-8 - use U_CONVERTSYMBOL

U_CONVERTSYMBOLS

function from adhoc

Entrypoint u_convertsymbols compatible with UTF-8

Inputs/Outputs

 Input    CSTRING(32760)   String in which characters should be replaced
          CSTRING(254)   String 2 with all characters to be  replaced
          CSTRING(254)   String 3 with characters to  replace with characters at the same place in string 2
 Output   CSTRING(32760)   String in which all characters where replaced with characters from string 3

Syntax

 TestSQL           
 SELECT '(a+ab)-abc*a+b=c' AS ISCORRECT, F_CONVERTSYMBOLS('(1+12)-123*1+2=3', '123', 'abc') FROM 
 RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_CONVERTSYMBOLS(NULL, NULL, NULL) FROM RDB$DATABASE;