You never know when you're going to encounter data ravaged by clients, cast aside and mauled, an antelope passed by lions to jackals.

But fortunately, data is much easier to repair than a gaping wound.

Here's the SQL query I'd use to replace non-breaking spaces with regular spaces. You'll need to replace it with whatever your search term is: