Use the @STRTRIM function to trim leading and trailing spaces.
@STRTRIM
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)
Scripting on this page enhances content navigation, but does not change the content in any way.