Stored Procedures for sum

[prprogrammer]

I need a sp to sum one column and return the sum value but if the sum is nothing i need to return 0 right the sp return null values right now.

my sp

create procedure dbo.name
@var1 int output
as
select @var1 = sum(field) as total......

 

[Pattycake245]

create procedure dbo.name
@var1 int output
as
select @var1 = isnull(sum(field),0) as total

Tim

 

[prprogrammer]

ok ....thanks...