I usually use COALESCE but ISNULL is easier to spell.

Thanks!

Good question, btw. lots of people haven't seen this trick and it's incredibly useful for generating D-SQL and executing it.