Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateExternal functions (UDFs) → ltrim
Firebird Home Firebird Home Prev: lpadFirebird Documentation IndexUp: External functions (UDFs)Next: *nullif

ltrim

Library: ib_udf

Changed in: 1.5, 1.5.2

Description: Returns the input string with any leading space characters removed. In Firebird 1.0.x, this function returns NULL if the input string is empty or NULL. In 1.5 and above it returns '' (an empty string) in these cases.

Return type: CHAR(n)

Syntax (unchanged): 

ltrim (str)

Declaration: 

DECLARE EXTERNAL FUNCTION ltrim
   CSTRING(255)
   RETURNS CSTRING(255) FREE_IT
   ENTRY_POINT 'IB_UDF_ltrim' MODULE_NAME 'ib_udf'

Notes

  • In Firebird 1.5.1 and below, the default declaration uses CSTRING(80) instead of CSTRING(255).

  • Depending on how you declare it (see CSTRING note), this function can accept and return strings of up to 32767 characters.

Prev: lpadFirebird Documentation IndexUp: External functions (UDFs)Next: *nullif
Firebird Documentation IndexFirebird 1.5 Language Ref. UpdateExternal functions (UDFs) → ltrim