First time I've come across this. Imported some data from Excel 2010 into SQL Server Table. Tried to match against some other data already in SQL Server and notice certain values where not matching even though to the naked eye these look exactly the same and the
field is the same varchar.
So did a quick HexEdit check (thanks Visual FoxPro for this handy tool) and found the following:-
like in Excel or in the import process a space (last 3 characters) has been translated into:-
Normally I see space in SQL as:-
So a quick REPLACE(Field, CHAR(160), CHAR(32)) and now the values match.