Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

LOWER function [String] Next Page

LTRIM function [String]

Trims leading blanks from a string.


LTRIM( string-expression )


string-expression    The string to be trimmed.


The actual length of the result is the length of the expression minus the number of characters removed. If all of 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.

See also
Standards and compatibility

The following statement returns the value Test Message with all leading blanks removed.

SELECT LTRIM( '     Test Message' );