LTRIM

Returns a character expression after it removes leading blanks.

Syntax

LTRIM ( string_expression ) 

Arguments

string_expression
A valid string expression.

Return Type

Returns values of type STRING.

Examples

Examples in this section use the example blockchain.

The following example returns the input after removing leading blanks.

SELECT LTRIM("   " + str) FROM example;

Response:

LTRIM("   " + str) [STRING]
NULL
d
lect
dialect