• ⌂ Text
• Functions
  • CHAR_LENGTH()
  • CONCAT()
  • ENUM()
  • FIND_ALL_IN_SET()
  • FIND_ANY_IN_SET()
  • FIND_IN_SET()
  • INSTR()
  • LEFT()
  • LENGTH()
  • LOCATE()
  • LOWER()
  • LPAD()
  • LTRIM()
  • MATCHES()
  • ORD()
  • REVERSE()
  • RIGHT()
  • RPAD()
  • RTRIM()
  • SUBSTR()
  • SUBSTRING()
  • TRIM()
  • UPPER()

LTRIM()

Returns a string with leading space characters removed.  Returns NULL if the string is NULL.

Prototype

string LTRIM(string str)

Parameters

• str - The string to remove the leading space characters from.

Return

Returns str with leading space characters removed.  Returns NULL if the str is NULL.

Example

Remove leading spaces from a contact name.

SELECT LTRIM(Name) AS TrimmedName FROM Contact

Related

RTRIM(), TRIM()

• < LPAD()
• MATCHES() >