meta data for this page
  •  

F_LEFT(F_LEFT4, F_LEFT8), F_BIGLEFT

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

Entrypoint left not compatible with UTF-8 - use U_LEFT(U_LEFT4, U_LEFT8)

U_LEFT(U_LEFT4, U_LEFT8)

function from adhoc

Entrypoint u_left compatible with UTF-8

Inputs/Outputs

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

Syntax

  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;