<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	SQL COALESCE() Like ISNULL() On Steroids ... With Caveats
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:195.view
	
	Date Posted:
	Aug 4, 2006 at 5:04 PM
	
---- --------------------------------------------------------------------------------------- --->


SELECT
	COALESCE(
		business_phone,
		cell_phone,
		pager 
	) AS phone_number
FROM
	contact