LTRIM (SYSFUN schema) scalar function

Returns the characters of the argument with leading blanks removed.

Read syntax diagramSkip visual syntax diagramLTRIM(expression)
The schema is SYSFUN.
expression
An expression that returns the built-in character string or Boolean value that is to be trimmed. The maximum length is:
  • 4000 bytes for a VARCHAR
  • 1,048,576 bytes for a CLOB

Result

The data type of the result is:
  • VARCHAR(4000) if the data type of the expression is CHAR or VARCHAR
  • CLOB(1M) if the data type of the expression is CLOB or LONG VARCHAR

The result can be null; if the expression is null, the result is the null value.