weird character in DB resultset

So I'm running a query against my database and looping through the results and ge开发者_Go百科tting something like-

F.�B.�Webster�Day�

in most of the results. Those should be spaces but it must've been something weird during the import/conversion (damn you M$).

Is there a quick query I can run against the DB to remove all of those and replace them with spaces?

IS there anyway you can get a HEX dump of the output?

From the looks of it these characters probably started life as the NBSP (non breaking space character) x'A0', but they may have been mistranslated to something else.

If it is you can easily fix this using the REPLACE() function in an update statement.

it should be a different collaption from the two databases... try to change the db collaption as the old...