UFN_NON_NULL_SITE_EXISTS

            CREATE function dbo.UFN_NON_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_NULL_SITE_EXISTS 
      verifies this condition.*/

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


                /*declare @NULLCOUNT int;
        if @SITEID is not null
          return 1;

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

                if (@NULLCOUNT = 0)
                    return 1;*/

                return 0;
            end