Steve,
To the best of my knowledge NO!
Per "Understanding The New SQL: A Complete Guide"
COALESCE (value1, value2, ... valuen)
If vaule1 is not null, the the value of the COALESCE is value1,
if value1 is null, then value2 is checked. This continues until
either a non-null value valuei is found--in which case, the
value of the COALESCE is valuei-- or ever value, including
valuen is found to be null-in which case, the value of the
COALESCE is NULL.
At best you can simulate COALESCE by having nested IFNULL or
IFEXISTS.
Jim Bentley
--- "Wills, Steve" <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
>
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
