<--- --------------------------------------------------------------------------------------- ----
	
	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( 
		-- DB date/time field.
		began_dating, 
		 
		-- System date/time.
		getDate(), 
		 
		-- Text expression
		'sometime' 
	) AS began_dating
FROM
	girl