fnFundRaiserConfirmationCodeIsOK

                  CREATE function [dbo].[fnFundRaiserConfirmationCodeIsOK]
    (    
    @ConfirmationCode uniqueidentifier
    )
    returns bit
    as
    begin
    declare @OK bit
    if not exists (select top 1 [ID] from dbo.FundRaiserSolicitors 
            where ConfirmationCode=@ConfirmationCode
            and Inactive=0)
        set @OK=1
    return @OK
    end