Entrypoint space compatible with UTF-8
Input INTEGER number of blanks Output CSTRING(32760) blank chain (CHR(32)) with indicated numbers
TestSQL SELECT F_STRINGLENGTH(F_SPACE(10)) || ' Leerzeichen und ein x' AS ISCORRECT, F_SPACE(10) || 'x' FROM RDB$DATABASE;
Counting starts with 1 TestSQL SELECT 'Dies i' AS ISCORRECT, F_LEFT('Dies ist ein Test', 6) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_LEFT(NULL, NULL) FROM RDB$DATABASE;