fnFundraiserSolicitorIDByConfirmationCode

            create function [dbo].[fnFundraiserSolicitorIDByConfirmationCode]
            (    
            @ConfirmationCode uniqueidentifier
            )
            returns int
            as
            begin
            declare @ID int
            select top 1 @ID =[ID] from dbo.FundRaiserSolicitors 
                    where ConfirmationCode=@ConfirmationCode
            return @ID
            end