LTRIM

Description

The LTRIM function is used to remove consecutive spaces or specified characters from the left side (leading) of a string.

Syntax

LTRIM( <str> [, <trim_chars> ] )

Parameters

Parameter	Description
<str>	String that need to be trimmed
<trim_chars>	Optional Parameter. If this parameter is provided, the LTRIM function will remove all characters from the <trim_chars> that appear on the left side of <str>. If this parameter is not provided, the LTRIM function will only remove the space character to the left of '<str>'.

Return Value

Returns a string with leading spaces or <trim_chars> removed. Special cases:

• If any Parameter is NULL, NULL will be returned.

Examples

SELECT ltrim('   ab d') str;

+------+
| str  |
+------+
| ab d |
+------+

SELECT ltrim('ababccaab','ab') str;

+-------+
| str   |
+-------+
| ccaab |
+-------+