Re: select null ?

}>From ilist@rmy.emory.edu Tue Jul 8 14:11:47 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id OAA28669; Tue, 8 Jul 1997 14:11:45 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id NAA19936 for informix-list-out; Tue, 8 Jul 1997 13:45:01 -0400 (EDT) }>From: weberj@t-online.de (Juergen Weber) }>Message-Id: <5psv6h$c3u$1@news01.btx.dtag.de> }>Subject: select null ? }>Date: 8 Jul 1997 08:53:37 GMT }>Reply-To: weberj@schwend.de }>Organization: Druckerei E. Schwend GmbH }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.40196> }> }>I tried with informix workgroup server: }> }>SELECT Spalte1, Spalte2, NULL, ..., NULL }> FROM Table1 }> UNION ALL }> SELECT NULL, NULL, Spalte3, Spalte4, ..., NULL }> FROM Table2 }> }>This is not possible. }>Then I found that not even "SELECT null AS xx FROM tab" is possible, }>which works in sybase and access. }> }>Why is this that way? }> }>Thanks for any hints, }> }>Juergen }> I do not know if it is functionally equivalent, but you could do "SELECT '' AS xx FROM tab". I agree that it seems strange that you cannot SELECT NULL. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------