RE: How to show Null expression in SQL query ?

With IDS 7.3 you can return NULL from a case construct: SELECT tabid, CASE WHEN 1=1 THEN NULL END AS col1 FROM systables WHERE tabid = 1; -----Original Message----- From: rfurdzik@paulweiss.com [mailto:rfurdzik@paulweiss.com] Sent: Friday, December 11, 1998 13:24 To: informix-list@iiug.org Subject: How to show Null expression in SQL query ? Does anybody knows how to show Null expression in SQL query ?. I tried something like this: "SELECT NULL As col1 FROM... " , but it did not work. Any idea ? __________________________________________________ This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank You. __________________________________________________