Discussion on:

Message 1 of 2
0 Votes
+ -
Another Take
There is some benefit to the way comparisons work. Rather than a problem, the "wrong" values can alert you to something amiss in the data. Using a TRIM or whatever other modification so "similar" strings match sort of removes this usage.

I guess I often use it as an initial filter to see if the data is clean.
Posted by dogknees
22nd Nov 2011