CODE EXAMPLE FOR SQL

difference between ltrim and rtrim in sql server

LTRIM() removes leading spaces from the string (spaces on the left side)
RTRIM() removes the trailing spaces.