[thelist] SQL Challenge Question

[Jay Blanchard]

[snip]
I've got an SQL Challenge for you.

	Given: Two nearly Identical Rows
	Problem: Isolate the columns where the data
		   is not the same.
	Solution: ?

Can this be done? If so, how?
[/snip]

Cannot really be done in SQL in one shot, but you could do it
programmatically. For each column SELECT DISTINCT(foo) and compare each
value in the column with the previous  value in the column, especially
if you have many rows and columns to check.