Removes leading and trailing blanks from a string.
LTRIM( string-expression )
string-expression The string to be trimmed.
VARCHAR
NVARCHAR
LONG VARCHAR
LONG NVARCHAR
The actual length of the result is the length of the expression minus the number of characters removed. If all the characters are removed, the result is an empty string.
If the parameter can be null, the result can be null.
If the parameter is null, the result is the null value.
This function supports NCHAR inputs and/or outputs.
SQL/2003 Vendor extension.
The TRIM specifications defined by the SQL/2003 standard (LEADING and TRAILING) are supplied by the SQL Anywhere LTRIM and RTRIM functions respectively.
The following statement returns the value Test Message with all leading blanks removed.
SELECT LTRIM( ' Test Message' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |