Re: Null in SQL select union

I don't know how you would specify null in such a statement otherwise, or 
if it is allowed.  However, perhaps you could create a Design Change 
Request to allow you to do so.
http://faq.midrange.com/data/cache/189.html

As far as better English, I am not an expert.  Practice and motivation. 
When you type an email check the spelling and punctuation.  Don't rely 
upon your spell checker, (I almost spelled rely as relay.)  And when it 
does correct a word, take the time to see how.  That will allow you to 
improve your spelling in general, and to understand our little rules (like 
i before e except after c, and the various exceptions which prove the 
rule).  Understand when and how to use colon's, semi colons, periods - and 
use them.  Yes we are supposed to be all technogeeks and not care about 
the layout of our email - but it still matters.  Some may cringe, but 
perhaps TV with the closed captioning, in English, turned on.  Granted, 
closed captioning 'shorthand's' a few words out.

However Titus, I don't think it was your English.  I think some of us work 
better with examples.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com