Left trim text | TEXT_TRIM_LEFT
Syntax
TEXT_TRIM_LEFT( [value] )Parameters
value
The TEXT to trim.
If it is not a TEXT value, it will be converted to one with the STRING operation.
Return Value
A new TEXT with all the white-space characters removed from the start of VALUE.Description
Remove white-space from the start of a TEXT.Examples
TEXT_TRIM_LEFT(" four score and seven years ") # returns "four score and seven years "TEXT_TRIM_LEFT("") # returns ""TEXT_TRIM_LEFT(null) # returns ""TEXT_TRIM_LEFT(1234) # returns "1234"