LTRIM function
LTRIM is a string manipulation function, used for manipulating all data types (BIT, BLOB, and CHARACTER), that returns a character string value of the same data type and content as source_string, but with any leading default singletons removed.
Syntax
The term singleton is used to refer to a single part (BIT, BLOB, or CHARACTER) within a string of that type.
The LTRIM function is equivalent to TRIM(LEADING FROM source_string).
If the parameter is NULL, the result is NULL.
The default singleton
depends on the data type of source_string:
Character | ' ' (space) |
---|---|
BLOB | X'00' |
Bit | B'0' |