Entrypoint lrtrim compatible with UTF-8
Input CSTRING(8190) String whose leeding and trailing blanks should be removed Output CSTRING(8190) String without leeding and trailing blanks
Does not remove the protected blanks (with < ALT > < 255 >) TestSQL SELECT 'Dies ist ein Test' AS ISCORRECT, F_STRINGLENGTH(F_LRTRIM(' Dies ist ein Test ')) AS ANZ_ZEICHEN, F_LRTRIM(' Dies ist ein Test ') FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_STRINGLENGTH(F_LRTRIM(NULL)) AS ANZ_ZEICHEN, F_LRTRIM(NULL) FROM RDB$DATABASE;