LTRIM

​

Syntax

​

Scalar

ltrim(value)

​

Custom characters (scalar)

ltrim(characters, value)

• In the two-argument form, pass the characters to remove first and the text to trim second: (characters, subject).

​

Arguments

​

Scalar

​

Custom characters

​

Returns

• Type: STRING
• NULL behavior: NULL subject returns NULL; an empty subject remains empty.

​

Properties

​

Usage notes

• The one-argument form removes space characters.
• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT ltrim('  Hello  ') AS "value";

​

Choose the characters to remove

SELECT ltrim('.', '..hello..') AS trimmed;

​

Limitations

• In the two-argument form, pass the characters to remove first and the text to trim second: (characters, subject).

​

Related functions

• trim