You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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).

memsql> select rtrim('    ohai     ') as r, ltrim('    ohai     ') as l;
+----------+-----------+
| r        | l         |
+----------+-----------+
|     ohai | ohai      |
+----------+-----------+

Related Topics