This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

LTRIM

Removes all occurrences of optionally specified characters, <trimchars_expr>, from the left side of a source string <srcstr_expr>. If no <trimchars_expr> are specified, removes all occurrences of common whitespace (ASCII Decimal 32) characters from the left side of the specified source string.

Syntax

LTRIM(<srcstr_expr>[, <trimchars_expr>])

Parameter	Description
`<srcstr_expr>`	An expression that returns the string to be trimmed. The string can be any of the string data types.
`<trimchars_expr>`	Optional. An expression that returns characters to trim from the left side of the `<srcstr_expr>` string. If omitted, whitespace (ASCII Decimal 32) is assumed.

Examples

Default whitespace trim.

SELECT
  LTRIM('  Hello, world!     ') AS trmdstrng;

Returns:

+-----------------+
|trmdstrng        |
+-----------------+
|Hello,world!     |
+-----------------+

Single character trim, with whitespace not specified and left as a remainder.

SELECT
  LTRIM('xxx    Hello, world!', 'x') AS trmdstrng;

Returns:

+----------------+
|trmdstrng       |
+----------------+
|    Hello,world!|
+----------------+

Multiple character trim, with all specified characters removed, regardless of ordering.

SELECT
  LTRIM('yyxxyx  Hello, world!', 'xy') AS trmdstrng;

Returns:

+--------------+
|trmdstrng     |
+--------------+
|  Hello,world!|
+--------------+