LTRIM( string-expression )

• 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.

• RTRIM function [String]
• TRIM function [String]
• UltraLite string functions

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

SELECT LTRIM( '     Test Message' );