RE: How to show Null expression in SQL query ?

I need to create an union query, so number and type of column must be the=20 same=2E I want to replace missing columns with NULL's, so client applicatio= n will=20 show nothing for those missing columns=2E "Bernstein, Rick" <rbernste@alarismed=2Ecom> on 12/11/98 04:40:32 PM To: Rafal Furdzik/PaulWeiss, "!INFORMIX-list (E-mail)" <informix-list@iiug=2E= org> cc: =20 Subject: RE: How to show Null expression in SQL query ? With IDS 7=2E3 you can return NULL from a case construct: SELECT tabid, CASE WHEN 1=3D1 THEN NULL END AS col1 FROM systables WHERE tabid =3D 1; -----Original Message----- From: rfurdzik@paulweiss=2Ecom [mailto:rfurdzik@paulweiss=2Ecom] Sent: Friday, December 11, 1998 13:24 To: informix-list@iiug=2Eorg Subject: How to show Null expression in SQL query ? Does anybody knows how to show Null expression in SQL query ?=2E I tried something like this: "SELECT NULL As col1 FROM=2E=2E=2E " , but it did not work=2E Any idea ? __________________________________________________ This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL=2E If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited=2E If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately=2E Thank You=2E __________________________________________________ __________________________________________________ This message is intended only for the use of the=20 Addressee and may contain information that is=20 PRIVILEGED and CONFIDENTIAL=2E If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited=2E If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately=2E Thank You=2E __________________________________________________