I too go with using ISNULL because I discovered it before COALESCE.
For multiple NULL values until I discovered COALESCE, I'd just chain ISNULL's
ISNULL(<test value>,ISNULL(<test value 2>,<final value))
etc.
--Mark Tassin MCITP - SQL Server DBA Proud member of the Anti-RBAR alliance. For help with Performance click this link[/url] For tips on how to post your problems[/url]