how to prevent one space in sql fields in the left code example Example: remove spaces sql 2008 SELECT RTRIM(LTRIM(' Word '))