meta data for this page
  •  

F_REPLACE(F_REPLACE4, F_REPLACE8), F_BIGREPLACE

compatibility to FreeUDFLibC

Entrypoint replace compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(32760)      string where a character string had to be exchanged
              CSTRING(254)        old string
              CSTRING(254)        new string
   Output     CSTRING(32760       string with replaced characters from parameter 2 with characters 
                                  from parameter 3

Syntax

   Easy version of the funktion F_REPLACESTRING without the posibility to change the string more than one time and 
   independent of upper and lower case.
   TestSQL           
   SELECT 'Dies ist ein Versuch zwei Versuch drei Versuch vier TEST' AS ISCORRECT, F_REPLACE('Dies ist ein Test zwei Test 
   drei Test vier TEST', 'Test', 'Versuch') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_REPLACE(NULL, NULL, NULL) FROM RDB$DATABASE;