![LOWER function [String]](arrow-left.gif){kind=icon}
![MAX function [Aggregate]](arrow-right.gif){kind=icon}
Removes leading blanks from a string.
LTRIM ( string-expression )
string-expression The string to be trimmed.
The
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.
The following statement returns the value “Test Message” with all leading blanks removed:
SELECT LTRIM( ' Test Message' ) FROM iq_dummy
