Use sysobjects and Syscolumns to find each column of each table. If the column type is a string, such as VARCHar, nvarchar, etc., update the columns with cursors.


Here’s an example of what you need to change


A. xtype in(167,231) 167 and 231 are xtype values of vARCHAR and nvarchAR columns found in systypes system tables. If other types of columns are also injected, add them to 167 and 231 as required.


Also, update statements


set @sqlstr=’update [‘+@tname+’] set [‘+@colname+’]=replace([‘+@colname+’],”