0 - 1 of 1 tags for @Altide

Hi,
I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").