Re: Oracle NVL equivalent ?

On Wed, 17 Dec 1997, Peter Robinson wrote: > We are currently porting one of our applications to > unix/informix HP 9.04/online 6 from NT/Oracle 7 > > We currently use NVL to return a value (0) in place of a null in a > select statement. Is there any equivalent in Informix? This was discussed a couple of weeks ago in this group. Try http://www.dejanews.com to dig out the full answer. Succinctly: not in current versions, but will be in 7.30. In the interim, it is not very hard to write a stored procedure which does the job -- the hardest part is deciding what the default should be for every type. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>