/*results.asp case=Region*/ SELECT MarkerID, Marker, Memorial INTO #R6049456Region1042319737 FROM Markers WHERE Accepted Is Not Null AND Withdrawn Is Null And Rejected Is Null AND ReplacedByID is Null AND ( EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3700AND rl.AllCountry = 1 AND Markers.Country = rl.Country) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3700 AND rl.AllState = 1 AND Markers.Country = rl.Country AND Markers.State = rl.State) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3700 AND rl.AllCountry = 0 AND rl.AllState = 0 AND rl.Zip = '' AND Markers.Country = rl.Country AND Markers.State = rl.State AND Markers.County = rl.County) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3700 AND rl.AllCountry = 0 AND rl.AllState = 0 AND rl.Zip != '' AND rl.Country = 'United States of America' AND Len(rl.Zip) > 4 AND Markers.Country = rl.Country AND Markers.Zip = rl.Zip) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3700 AND rl.AllCountry = 0 AND rl.AllState = 0 AND rl.Zip != '' AND (rl.Country <> 'United States of America' OR Len(rl.Zip) <= 4) AND Markers.Country = rl.Country AND Markers.Zip LIKE rl.Zip + '%') )