• I know CAST will allow you to change it to a VARCHAR, and you'll end up with a variety of ? in the items for non-ASCII characters.

    Perhaps you can somehow search for those placeholders and if they aren't there (CHARINDEX=0), you can do your processing?