ltrim

Description

ltrim removes leading characters from a string.

The default value for chars is ' ' (a single space character). If chars is not specified, ltrim removes all leading spaces.

See also trim, rtrim.

Return type

string

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

ltrim(str, [ chars ])

Argument

Type

Optional

Repeatable

Restrictions

str

string

no

no

none

chars

string

yes

no

constant

Examples

make_col trimmed_kind:ltrim(bundle_kind, ' ')

Removes leading spaces from bundle kinds