I am stumped and can't find the answer on google.

I need to create a query that finds any characters in a text/varchar field that has any extended ASCII characters. We want to remove any extended ASCII characters. This is in SQL 2008 SP1.

Example:
Select * from MyTable
where there is an ascii character in MyField

Thanks in advance,


Edit by admin: no contact info permitted on the forum, thank you