Find a partial number in row to a tabel

Hello, all

please help me before i get suicide , this is the scenario :

i have tariff table look like this :

countrycodeprefix tariff
x?????? ?????

and i have traffic table like this :

A# B# Duration
x?????????? 9x?????????? $???

i have to find (and match) a tariff from tariff table based on B# in traffic table based on B# in traffic number, the B# contain 9(international code)x?????????(contain country code and prefix) . The problems is the countrycodeprefic from tariff table contains a list of country code and prefix that is very various (from 1 digit until 6 digit) , how could i match this ...?

PLeaseeeeee help me,

Regards

Alex