UFN_CONSTITUENTMATCH_TITLESCOREDEDUCTION_BYRESULT

            create function dbo.UFN_CONSTITUENTMATCH_TITLESCOREDEDUCTION_BYRESULT (
                @TITLERESULT tinyint
            )
            returns table -- Writing as in-line table for performance vs scalar function

            with schemabinding
            as return
                -- minimal deductions for different titles unless genders are different

                -- in that case manual review if all else is likely match or higher

                select 
                    case @TITLERESULT
                        --when 0 then 0 

                        when 1 then 1 
                        when 2 then 2 
                        when 3 then 18 
                        else 0 
                    end as DEDUCTION;