i have a very simple S/P called ClaimTotal

CREATE PROCEDURE ClaimTotal
@Result varchar(50) OUTPUT 
as
select sum(total) as Ctotal
from claim

i am struggling to get the Ctotal saved into the @result so that i can
then pull this into my .net program.

if anyone could help that would be very helpfull

thanks in advanced.

CREATE PROCEDURE ClaimTotal
@Result varchar(50) OUTPUT 
as
select sum(total) into Result 
from claim