Remove Non ASCII characters from MSSQL

Here's a function that accepts a unicode string and return a varchar string after removing the invalid ASCII characters. Just call it for each column you need to clean up.