It is a late answer, but I needed the same and didn't find the exisiting answer good enough.
The solution happens to be simpler:

select * from yourTable where yourColumn COLLATE Latin1_General_BIN LIKE '%[^ -~]%'

• COLLATE Latin1_General_BIN: sets the collation so that comparisons are byte-sensitive. Without this the following pattern match will not work.

• [^ -~]: This a pattern matches any character not in the ASCII printable range (space to tilde). Diacritic characters (accents) fall outside this range.