Entrypoint replace compatible with UTF-8
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
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;