Use the @STRLTRIM function to trim leading spaces.
@STRLTRIM
Syntax
@STRLTRIM (string)
string
Can be the name of a character column or a literal string. Enclose literals within quotes.
Example
birth_state = @strltrim(state)
Scripting on this page enhances content navigation, but does not change the content in any way.