This query will do it.
declare @sql VARCHAR(8000)
declare @tableName SYSNAME
set @tableName = 'yourTableNameGoesHere'
set @sql = 'UPDATE ' + @tableName + ' SET ' +
(
select QUOTENAME(COLUMN_NAME) + ' = UPPER(' + QUOTENAME(COLUMN_NAME) + '), '
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = @tableName
AND
DATA_TYPE IN('char','varchar','nchar','nvarchar')
order
by ORDINAL_POSITION
for xml path('')
)
---- remove last ", "
set @sql = LEFT( @sql, LEN(@SQL)-1)
print @sql
---- uncomment next line to execute the query
--exec (@sql)