LTRIM function [String]

Function

Removes leading blanks from a string.

Syntax

LTRIM ( string-expression )

Parameters

string-expression The string to be trimmed.

NoteThe result data type of an LTRIM function is a LONG VARCHAR. If you use LTRIM in a SELECT INTO statement, you must have a Large Objects Management option license or use CAST and set LTRIM to the correct data type and size.

See “REPLACE function [String]” for more information.

Example

The following statement returns the value “Test Message” with all leading blanks removed:

SELECT LTRIM( '     Test Message' ) FROM iq_dummy

Standards and compatibility

See also

“RTRIM function [String]”

“TRIM function [String]”