Free Software, Source Code, and Best-Practice Documentation Index from your
Cleveland Software, Database, Web Design, Consulting, and SQL / Delphi Experts

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[udfNullableIntegerCompare]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[udfNullableIntegerCompare]
GO

CREATE FUNCTION udfNullableIntegerCompare 
	(@iInteger1	INT,
	 @iInteger2	INT )
RETURNS BIT
AS
BEGIN

--If the expression returns ZERO, the column values are not equal, otherwise, if it returns ONE, the column values are equal.
-- We then use a case statement to flip the value. 
RETURN (CASE
		WHEN (@iInteger1 IS NULL AND @iInteger2 IS NOT NULL) OR (@iInteger2 IS NULL AND @iInteger1 IS NOT NULL) THEN 0
		ELSE ( 1 - ABS( SIGN( ISNULL( @iInteger1, 0 ) - ISNULL( @iInteger2, 0) ) ) )
	END)

END