Tidy badly encoded DB TABLE french chars
These few SQL lines came in handy when wanting a quick-fix for a poorly imported table UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î') http://stackoverflow.com/questions/5127744/how-to-convert-these-strange-characters-%C3%83-%C3%83-%C3%83%C2%AC-%C3%83%C2%B9-%C3%83