I imported data into SQL Server using a link server. Imported an Excel version and a CSV version. One cell has some fields with this weird character. It isn't a dash or underscore.
Underscore, dash, weird character
_ - −
CSV Highland Park âˆ’ 546
Excel Highland Park − 546
My goal is to use the import Excel version and be able to identify any field that has the weird character. I tried CHAR and ASCII to try and identify/deal with this and can't seem to solve the puzzle. Any ideas would be appreciated. Thanks you.
SELECT * FROM ExcelVersion WHERE MyField = '−'