<!--- Test the COALESCE() SQL method. --->
<cftimer label="COALESCE" type="outline">
	 
	<cfquery name="qCoalesce" datasource="...">
		SELECT
			id,
			COALESCE( date_created, getDate() ) AS date_created
		FROM
			web_stats_hit
		WHERE
			COALESCE( date_created, getDate() ) IS NOT NULL
		AND
			COALESCE( id, 0 ) IS NOT NULL
	</cfquery>
 
</cftimer>
 
<!--- Test the ISNULL() SQL method. --->
<cftimer label="ISNULL" type="outline">
	 
	<cfquery name="qIsNull" datasource="...">
		SELECT
			id,
			ISNULL( date_created, getDate() ) AS date_created
		FROM
			web_stats_hit
		WHERE
			ISNULL( date_created, getDate() ) IS NOT NULL
		AND
			ISNULL( id, 0 ) IS NOT NULL
	</cfquery>
 
</cftimer>