LTRIM function [String]

Function

Removes leading blanks from a string.

Syntax

LTRIM ( string-expression )

Parameters

string-expression The string to be trimmed.

Example

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

SELECT LTRIM( '     Test Message' ) FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase Compatible with Adaptive Server Enterprise.

See also

“RTRIM function [String]”

“TRIM function [String]”