Removes any leading spaces from a string.

Syntax

---

LTRIM(<StringExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as input

Usage

---

The LTRIM function removes any leading spaces from a string.

Examples

---

SELECT LTRIM(Name) AS Name
AS Customers

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: