What I would like to do is be able to create a field that would compare 2 database that have a "phone" field relationship. What I am tryomg to do is compare just the area code & prefix between t

[jbowley]

What I would like to do is be able to create a field that would compare 2 database that have a "phone" field relationship.

What I am tryomg to do is compare just the area code & prefix between the 2.

I can get it to match exact matches but not just the first 7 characters.

Example if on database has 222-333-4000

& one I am comparing has 222-333-4100 and 222-333-4200

that it would tagg both of these just from the first 7 characters 222-333.

I tried

If ( Left(Phone;7) = Left(TBN_ADM_IC_231::Phone;7) ; " -DJM- " ; "")

but i still only get hits on exact matches not partial.

Also tried PatternCount (Left(TBN_ADM_IC_231::Phone;7) ; Left(Phone;7)) same results.

Help!!

Edited September 19, 2007 by Guest