Another great reply; I currently ask my team to use COALESCE exclusively because it's ANSI standard and more flexible due to multiple parameters...but your reply leads me back to "any tool in the toolbox". In the case I stated, it appears that ISNULL would have been the better option...so now I'll check for situations where ISNULL should be used instead of COALESCE.

This is why I like this forum so much...I always get informed answers that I can trust (unlike many on the web), and usually from people who know this product and creative methods to use it.

Thanks again,

~ Jeff