ltrim

Removes leading blanks from the character expression. Only values equivalent to the space character in the current character set are removed.

Syntax

ltrim(char_expr | uchar_expr)

Parameters

char_expr – is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.
uchar_expr – is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1 – Removes the leading blanks before "123":
```
select ltrim("    123")
```
```
-------
123
```

Usage

If char_expr or uchar_expr is NULL, returns NULL.
For Unicode expressions, returns the lowercase Unicode equivalent of the specified expression. Characters in the expression that have no lowercase equivalent are left unmodified.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute ltrim.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com