6 Replies Latest reply: Mar 22, 2011 1:15 AM by s j RSS

    intervalmatch help?

      Im new in QV.

      My table is like this:

       


      load * inline [
      Country, postal_start, Postal_end, zones
      EN, 1000, 2599, 1
      EN, 5000, 7899, 3
      EN, 0000, 9999, 2
      MN, 0000, 9999, 5
      GR, 6000, 8999, 3
      GR, 0000, 9999, 2
      .....
      ];


      0000-9999 was null. i fill it 0000 to 9999 because i need to use intervalmatch to match some postal codes. And now problem is when i select some postal code like 1500 in EN its showing 2 rows inside of 0000-9999 and 1000-2599. I just need 1000-2599 this. How should i figure this out Please help.

      Regards PS:sorry for my bad English