UFN_SITEID_MAPFROM_COAUPDATEID

            create function dbo.UFN_SITEID_MAPFROM_COAUPDATEID
            (
                @COAUPDATEID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin
              insert into @SITES(SITEID)
        select COAUPDATE.SITEID from dbo.COAUPDATE where ID = @COAUPDATEID;

        if (select count(SITEID) from @SITES) = 0 --If no site has been assigned, then the address finder is unsecured and available to all sites.

        begin
          insert into @SITES(SITEID) values (null);
          insert into @SITES(SITEID) select ID from dbo.SITE;
        end

                return;
            end