UFN_CONSTITUENT_ISPATRON

            CREATE function dbo.UFN_CONSTITUENT_ISPATRON(@CONSTITUENTID uniqueidentifier) 
            returns bit
            with execute as caller
            as begin
                if exists (
                    select top 1 1
                    from
                        dbo.SALESORDER
                    left outer join  -- Left join since group sales may not have sales order items

                        dbo.SALESORDERITEM on SALESORDERITEM.SALESORDERID = SALESORDER.ID
                    where
                        SALESORDER.CONSTITUENTID = @CONSTITUENTID
                        and SALESORDER.STATUSCODE <> 0  -- Orders that aren't Pending

                        and (
                            SALESORDER.SALESMETHODTYPECODE = 3  -- Group Sales

                            or SALESORDERITEM.TYPECODE in (0, 14)  -- Ticket or Merchandise

                        )
                )
                    return 1;

                return 0;
            end