/****** Object:  User Defined Function dbo.ifnull    Script Date: 12/1/2005 11:50:34 PM ******/

CREATE FUNCTION [dbo].[ifnull](@expression sql_variant, @alternative sql_variant )  
RETURNS sql_variant AS  
BEGIN
    IF (@expression IS NULL)
        RETURN @alternative
    RETURN @expression
END
GO