5 Replies Latest reply on Oct 30, 2014 11:13 AM by philmodjunk

    Found set on a range

    Kirk_1

      Title

      Found set on a range

      Post

      This is the data I'm trying to do a found set on. A Zip code I could get from my customer is 84101. The snipit represents one record with this zip range in it... from 84087-84244. Because 84101 is not in/a the record, it will not produce a found set. 

      How do i structure my script so i get this range with out knowing the range. If I go over, or under I won't get the right found set. This is a UT zip for SLC. For this vendor they have 4 locations in UT. In other states they could have as many as 12 location in the state... which means if I don't hit it exactly it will put me into the next location instead of the one i want to do the found set on.

      Capture.PNG