Use the @STRLTRIM function to trim leading spaces.

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)