UFN_MEMBERSHIPLEVEL_GETNUMBEROFCARDS

            CREATE function dbo.UFN_MEMBERSHIPLEVEL_GETNUMBEROFCARDS
            (
                @MEMBERSHIPLEVELID uniqueidentifier
            )
            returns smallint
            with execute as caller
            as begin

                declare @CARDNUMBER smallint

                select
                    @CARDNUMBER = CARDSALLOWED
                from
                    dbo.MEMBERSHIPLEVEL
                where
                    ID = @MEMBERSHIPLEVELID

                return @CARDNUMBER

            end