>>Script Language and Platform: SQL Server 2000

Objective: To simulate MS-Access NZ function.

--Usage:

select dbo.NZ(NULL,'haha') as results

--results = haha

select dbo.NZ(123,'haha') as results

--results = 123

select dbo.NZ('ABCDE','haha') as results

--results ABCDE

select dbo.NZ('ABCDE',0) as results

--results ABCDE

select dbo.NZ(NULL,1) as results

--results 1

Author: MAK

create function dbo.NZ (@a sql_variant,@y sql_variant)

returns sql_variant

as

begin

declare @myvar sql_variant

if isnull(@a,1) = 1

begin

set @myvar=@y

end

else

begin

set @myvar=@a

end

return @myvar

end

go

Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose... Disclaimer Continued

Back to Database Journal Home