STRTRIM

Use the @STRTRIM function to trim leading and trailing spaces.

Syntax

@STRTRIM (string)

string

Can be the name of a character column or a literal string. Enclose literals within quotes.

Example

pin_no = @strtrim(custpin)