CREATE FUNCTION CaseResourceCost (@meetID int) RETURNS decimal(12,2) AS BEGIN Declare @returnValue decimal(12,2) select isnull(sum(cocasedata.itemunitcost * coCaseData.ActualQty),0) as avgResCost FROM dbo.meetings INNER JOIN dbo.meetproc ON meetings.meetingnumber =meetproc.meetingnumber INNER JOIN dbo.cocasedata ON meetings.meetingnumber = dbo.cocasedata.meetingnumber where meetings.meetingnumber = @MeetID set @returnValue= avgResCost return (@returnValue) ENDBut I get the following error