SET QUOTED_IDENTIFIER ON

GO

ALTER TABLE M2.TensileRequirementsByGrade 
DROP COLUMN ElongationMin

ALTER TABLE M2.TensileRequirementsByGrade 
DROP COLUMN ElongationMax

UPDATE M2.TensileRequirementsByGrade
  SET Impact = REPLACE(Impact, 'Â°', '°')
  WHERE Impact LIKE '%Â°%';


UPDATE M2.TensileRequirementsByGrade
  SET Yield = REPLACE(Yield, 'N/mmÂ²', 'N/mm²')
  WHERE Yield LIKE '%N/mmÂ²%';

UPDATE M2.TensileRequirementsByGrade
  SET Tensile = REPLACE(Tensile, 'N/mmÂ²', 'N/mm²')
  WHERE Tensile LIKE '%N/mmÂ²%';