LTRIM function

The LTRIM function removes blanks from the beginning of a character string expression.

Syntax

LTRIM ( characterExpression )

A characterExpression is a CHAR, VARCHAR, or LONG VARCHAR data type, any built-in type that is implicitly converted to a string.

LTRIM returns NULL if characterExpression evaluates to null.

Example

-- returns 'asdf  '
VALUES LTRIM(' asdf  ')
Parent topic: Built-in functions