[RBASE-L] - Re: Does IFNULL(...) Approximate COALESCE(...)?

[Ken]

If this hasn't been answered, the answer is no. Coalesce will find the first non-null within a set. ifnull performs a similiar function to the nvl function in Oracle.

Regards, Ken

Wills, Steve wrote on 1/23/2008, 10:55 AM:

This might seem a bit obtuse, but I think I’m gonna’ have to be working w/some date-related issues, Calendar Periods versus Fiscal Periods, etc, so, does RBase’s IFNULL(...) approximate other vendors’ COALESCE(...)?

 

Thanks,

Steve in Memphis

 

 

J. Stephen Wills

Program Manager, Research Informatics

Office of the Vice Chancellor for Research

University of Tennessee Health Science Center

62 S. Dunlap, Suite 400

Memphis, TN  38163

Office: 901-448-2389

FAX    : 901-448-7133