if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[isempty]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[isempty]
GO
 
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
 
create function dbo.isempty (@passedval sql_variant, @returnval sql_variant)
returns sql_variant
as
begin
declare @returnval2 sql_variant
if (@passedval is NULL) or (@passedval = '')
begin
set @returnval2=@returnval
end
else 
begin
set @returnval2=@passedval
end
return @returnval2
end
 
 
 
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO