Solution to DISTINCT Case Problem
First off, take a look at my post from yesterday. I was given to understand that DISTINCT is not case-sensitive. The issue at hand actually has less to do with DISTINCT itself, and more to do with the character set and collation that are used when comparing strings. The best…