Create Procedure usp_DeleteCharFromTable
		@CharToDelete char(1)
As
Declare @SQLStr varchar(300)
-- You can alter the code so you can pass in the TableName
-- and look for the columns in the Information Schema column view
-- see BOL - Information Schema,
-- and build your dynamic sql string accordingly, to make 
-- the procedure more generic.

Set @SQLStr = ' Update TableName '
Set @SQLStr = @SQLStr +	' Set Col1 = Replace(Col1, ''' + @CharToDelete + ''', ''''), '
 ...
Set @SQLStr = @SQLStr +	' Col6 = Replace(Col6, ''' + @CharToDelete + ''', '')'
Set @SQLStr = @SQLStr +	' Where Col1 like ''%' + @CharToDelete + '%'''
Set @SQLStr = @SQLStr +	' OR Col2 like ''%' + @CharToDelete + '%'''
 ... 
Set @SQLStr = @SQLStr +	' OR Col6 like ''%' + @CharToDelete + '%'''
Exec (@SQLStr)

return (0)

-- Call from another SP 
Create Procedure usp_DeleteInvalidChar
As
Exec usp_DeleteCharFromTable '@'
Exec usp_DeleteCharFromTable '#'
Exec usp_DeleteCharFromTable '!'
...
return (0)

CREATE FUNCTION RemoveChars (@Str varchar(8000), @DelPat varchar(8000))
RETURNS varchar(8000)
AS
BEGIN
   DECLARE @Res varchar(8000), @i int
   SET @DelPat = '%[' + @DelPat + ']%'
   SET @Res = ''
   SET @i = PATINDEX(@DelPat, @Str)
   WHILE @i <> 0
   BEGIN
     SET @Res = @Res + SUBSTRING(@Str, 1, @i - 1)
     SET @Str = SUBSTRING(@Str, @i + 1, 8000)
     SET @i = PATINDEX(@DelPat, @Str)
   END
   SET @Res = @Res + @Str
   RETURN @Res
END


UPDATE TableName SET
  Col1 = RemoveChars(Col1, '^ A-Z0-9'),
  Col2 = RemoveChars(Col2, '^ A-Z0-9'),
  Col3 = RemoveChars(Col3, '^ A-Z0-9'),
  Col4 = RemoveChars(Col4, '^ A-Z0-9'),
  Col5 = RemoveChars(Col5, '^ A-Z0-9'),
  Col6 = RemoveChars(Col6, '^ A-Z0-9')