update 10 records out of 20 remove space from starting sql query code example Example: remove spaces sql 2008 SELECT RTRIM(LTRIM(' Word '))