Using Edit Replace. or the LEFT feature, etc.........you can either delete
the ST from table B items, or add it to table A items......

hth
Vaya con Dios,
Chuck, CABGx3


"JN" wrote:

Hi,

I am trying to match up a list of accounts (table A) from a huge text table
(table B). The problem is table A doesn't have the same format as the text
strings in table B. The text in table A contains part of the text strings in
table B.

For example,
Table A has 01A0000
Table B has ST1A0000

Thx!