Trims leading and trailing whitespace from every column in a SQL Server table

TrimAllColumns.sql

SET NOCOUNT ON;

DECLARE	@TABLE VARCHAR(100),
		@SQL VARCHAR(MAX);

SET		@TABLE = '';

SELECT @SQL = COALESCE(@SQL, '')
			+ CAST(	'UPDATE ' + @TABLE + ' ' +
					'SET [' + C.COLUMN_NAME + '] = LTRIM(RTRIM(' + C.COLUMN_NAME + ')) ' +
					'WHERE ([' + C.COLUMN_NAME + '] LIKE '' %'' ' +
					'OR [' + C.COLUMN_NAME + '] LIKE ''% ''); ' + Char(13)
			AS VARCHAR(MAX))

FROM	INFORMATION_SCHEMA.COLUMNS C
JOIN	sysobjects B
	ON	C.TABLE_NAME = B.NAME

WHERE	C.TABLE_NAME = @TABLE
AND		C.DATA_TYPE = 'varchar'
AND		B.xtype = 'U';

EXEC(@SQL);