Use trim function - TRIM(" Sample") = "Sample"
TRIM(FIELD_NAME) it will remove space from both leading and trailing.
2 of 2 people found this helpful
You cant try something like this. "1" indicates string has trailing spaces
If you wants to remove those spaces then you can do it in multiple ways
LTRIM() removes leading spaces from left side of the string
RTRIM() removes leading spaces from right side of the string
TRIM() removes leading spaces from both sides of the string
REPLACE([Strings], " ", "")
Hope this may help
Thank you for the reply, but it is not working for me ( I tried them earlier).