Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

LTRIM

Removes leading space characters from the given string.

Syntax

LTRIM (str)

Arguments

  • str: any string or binary object

Return Type

String

Examples

Info

This function removes only space " " characters. Other whitespace characters like tab \t, newline \n, etc are preserved. It is equivalent to TRIM(LEADING " " FROM str).

SELECT RTRIM('    ohai     ') AS r, LTRIM('    ohai     ') AS l;
+----------+-----------+
| r        | l         |
+----------+-----------+
|     ohai | ohai      |
+----------+-----------+

Related Topics