Category: ASE: Functions: String Functions

ltrim()

The String Function ltrim() removes leading blanks from a given string.

Syntax of the String Function ltrim()

    ltrim ( char_expression | uchar_expression )
    

The parameters of the String Function ltrim()

"char_expression"
The parameter "char_expression" can be a column name, variable or constant and must of one of the datatypes char, varchar, nchar or nvarchar . If the parameter "char_expression" has a value of NULL then NULL will also be returned.

"uchar_expression"
The parameter "uchar_expression" can be a column name, a variable or a constant and must be of one of the datatypes unichar or univarchar If the parameter "uchar_expression" has a value of NULL then NULL will also be returned.

Example for the String Function ltrim()

    select ltrim("   &nbsp sybase")

    go

    -----

    sybase
    

See also:

ASE T-SQL - Aggregate Functions,
ascii(),
char(),
char(n),
charindex(),
char_length(),
compare(),
difference(),
lower(),
patindex(),
replicate(),
reverse(),
right(),
rtrim(),
sortkey(),
soundex(),
space(),
str(),
String Functions,
stuff(),
substring(),
to_unichar(),
uhighsurr(),
ulowsurr(),
upper(),
uscalar().