How do you find all values that are not nil?

[Frederick_Cheung]

With mysql at least, NULL is a magical value, any comparison with NULL always returns false. You need to use foo IS NULL or foo IS NOT NULL.

Fred