LTRIM

Removes characters from the beginning (left side) of a string.

This function corresponds to the ltrim(X, Y) function in SQLite.

• If only one argument column is provided, it removes leading spaces from the string.

• If the optional trimChars argument is provided, it removes any character present in trimChars from the beginning of the string in column.

If the input column is not a string, it is first coerced into one. A NULL input results in a NULL output.

Example

// Removes leading spaces: ltrim('  hello') -> 'hello'
select(LTRIM(StringLiteral("  hello"))).execute()

// Removes specified leading characters: ltrim('**--hello', '*-') -> 'hello'
select(LTRIM(StringLiteral("**--hello"), "*-")).execute()

// Using a column
select(LTRIM(Users.username)).from(Users)

Parameters

See also