Okay… I’ve managed to clean up the vast majority of the incorrect characters except for ?. I’m trying to use the command
update <table>
set <field> = replace(<field>,'?',' ');
but changing the ? to what I thought was a space gives me a black triangle. I’ve also tried without the space between the apostrophes but it doesn’t work either.
So, my question is how can I either completely delete the ?, or how can I change it to a blank space?