Month: November 2018

In SQL Server, not all spaces are equal

In SQL Server, not all spaces are equal

I recently had a challenge mapping attributes using a lookup table. I had the same customer name in two tables “bobs widgets”, but when I tried to join on the names, there was no match.┬áTo cut a long story short, there is more than one way to encode a space. This picks up from the…

Read More Read More