<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	SQL ISZERO() And NULLIF() For Dividing By Zero
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:473.view
	
	Date Posted:
	Jan 15, 2007 at 3:23 PM
	
---- --------------------------------------------------------------------------------------- --->


CREATE FUNCTION IsZero (
	@Number FLOAT,
	@IsZeroNumber FLOAT
)
RETURNS FLOAT
AS
BEGIN
 
	IF (@Number = 0)
	BEGIN
		SET @Number = @IsZeroNumber
	END
 
	RETURN (@Number)
 
END