ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

LTRIM function [String]

Function 

Trims leading blanks from a string.

Syntax 

LTRIM ( string-expression )

Parameters 

string-expression    The string to be trimmed.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

RTRIM function [String]

TRIM function [String]

Example 

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

SELECT LTRIM( '     Test Message' )