meta data for this page
  •  

F_LRTRIM(F_LRTRIM4, F_LRTRIM8)

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

F_BIGLRTRIM

input/output-compatibility to rFunc (TRIM, LONGTRIM)

Entrypoint lrtrim compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(8190)     String whose leeding and trailing blanks should be removed
   Output     CSTRING(8190)     String without leeding and trailing blanks

Syntax

   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;