UFN_NULL_SITE_EXISTS

            CREATE function dbo.UFN_NULL_SITE_EXISTS
            (
      @SITEID uniqueidentifier
            )
      /* This database can have one record with SITEID
      is null or many records with no SITEID is null.
      This function in conjunction with UFN_NON_NULL_SITE_EXISTS 
      verifies this condition.*/

            returns bit
            with execute as caller
            as begin
                -- Function is deprecated


                /*declare @NULLCOUNT int;

        if @SITEID is null
          return 1;

                select
          @NULLCOUNT = count(*)
                from
                    dbo.CHARITYCLAIMREFERENCENUMBER
                where
                    SITEID is null
          and REFERENCENUMBER is not null

                if (@NULLCOUNT > 0)
                    return 0;

                return 1;*/
                return 0;
            end