Ole,

<< And for the record, I think you've done an excellent job with keeping EDB
very close to the standard specifications. >>

Well, it's certainly made it much easier on us because it has allowed us to
maintain a certain core focus and spend more time on adding much more
valuable features and platforms.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< The reason I asked to start with was I thought COALESCE (as well as being
hard to spell) would have to do a test internally and by using IF I was
"doing the test for it".

What does COALESCE do then? >>

It does the same, however, the difference is that one is an IF test in
native, compiled code (COALESCE) while the other is a test in *SQL-compiled*
code.  The native code is slightly more efficient and direct.  And by
slightly, I mean very slightly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Thanks

Roy Lambert