Kas:

I do agree with you, but that is a different issue;

My point was about table design.

Your point is about 'query results'.

Both are valid.

The COALESCE function then comes into play.

--Shaun