UFN_REGISTRANT_GETFUNDRAISINGMINIMUM

   CREATE function dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUM 
   (  
    @ID uniqueidentifier  
   )   

   returns money   
   with execute as caller  
   as  
   begin  
    declare @returnFMMoney money  

  --get from REGISTRANTEXTENSION

    SELECT @returnFMMoney = RE.FUNDRAISINGGOAL FROM dbo.REGISTRANTEXTENSION RE
        WHERE RE.REGISTRANTID =  @ID

    IF @returnFMMoney IS NULL
        SET @returnFMMoney = 0

    return @returnFMMoney
   end