RE: NULL computed field

You did not mention your Informix version. With IDS 7.3, you can use the CASE statement: SELECT CASE WHEN 1 = 1 THEN NULL END as effective_return_date, ... > -----Original Message----- > From: wgoldenarm@my-deja.com [mailto:wgoldenarm@my-deja.com] > Sent: Wednesday, November 03, 1999 12:07 > To: informix-list@iiug.org > Subject: NULL computed field > > > Is there any way to make a NULL computed field? > > Specifically I have a union in which I want to make a corresponding > field null. Ex: > > SELECT informix.leave.effective_return_date, > "" as cleared, > "" as absent, > "Y" as Resident > FROM informix.leave > UNION > SELECT NULL as effective_return_date, **** where I want the null **** > informix.morning_attendence_check.mac_cleared, > "" as absent, > "Y" as Resident > FROM informix.morning_att_check> > > Sent via Deja.com http://www.deja.com/ > Before you buy. >