ok.... a custmer has a pull down list of rates like rate1, rate2, and rate three.

i made a table of rates with these fields
code, country, rate1,rate2,rate3...nrate
011575 Colombia .23 .24 .28 .n
011578 Peru .33 .38 .24 .n

in customer john doe i selected that the was going to have rate1..this is preseted by the enduser...
now....my customer screen has three pages...
on the first page is customer info
on page two goes a grid of a view with all the calls made....like

date numberdialed
05-01-99 011575834265

what i need to do is look at the first 6 digits of the number dialed on the view1 and match it to the code of the country and determin according to the preset rate that i gave the customer . THE QUETSIONS IS WHAT IS THE RATE OF THE CALL TO COLOMBIA THAT THE CUSTOMER MADE