ltrim

Description

Returns the specified expression, trimmed of leading blanks.

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

select ltrim("    123")

-------
123

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute ltrim.

See also

Functions rtrim