Entrypoint left not compatible with UTF-8 - use U_LEFT(U_LEFT4, U_LEFT8)
Entrypoint u_left compatible with UTF-8
Input CSTRING(254) INTEGER string length of the cut-off-string Output CSTRING(254) string cut on the number indication from left gives from parameter 2
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;