Have a look at the trim function I linked to above. You can specify characters that you need to have removed from the column. Either that or identify the guilty characters and do a big nested REPLACE but that could get messy.