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

Examples

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.

Related reference
rtrim