how to convert varchar field to decimal and remove all white spacessql code example Example: remove spaces sql 2008 SELECT RTRIM(LTRIM(' Word '))