SQL COALESCE() Like ISNULL() On Steroids ... With Caveats 

SELECT
	COALESCE(
		business_phone,
		cell_phone,
		pager 
	) AS phone_number
FROM
	contact

For Cut-and-Paste