在SQL Server里面过滤掉某列的空格

实际SQL:

查询：SELECT LTRIM(RTRIM(cloumn))
  FROM dbo.table;

更新：UPDATE TABLE SET code= ltrim(rtrim(cloumn))

分页查询：

SET @sql='SELECT * FROM
(
SELECT ROW_NUMBER() OVER (order by usercode asc, name '+ @nameOrderBy+' ,att_date asc) AS RowNumber, COUNT(1) OVER() AS TotalCount, * FROM #temptable
) AS overtimedetail
WHERE RowNumber BETWEEN '+ convert(nvarchar,( ( ( @pageIndex - 1 ) * @pageSize ) + 1 ))+'AND '+ convert(nvarchar, ( @pageIndex * @pageSize ))

exec(@sql)