remove black spaces in sql int field code example Example: remove spaces sql 2008 SELECT RTRIM(LTRIM(' Word '))