Syntax
LTRIM(Argument)
Description
The LTRIM SQL scalar function removes blanks or hexadecimal zeros from the beginning of a string argument.
The argument must be a string.
The length attribute of the result is the same as the length attribute of Argument. The actual length of the result is the length of the argument minus the number of bytes removed.
If all characters are removed, the result is an empty string.
If the first argument can be null, the result can be null; if the first argument is null, the result is the null value.
Example
Assume the column HELLO of type ALPHA(9) has a value of ' Hello'.
LTRIM(HELLO)
Results in: 'Hello'.
List of SQL scalar functions by topic