Jump to content

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

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

This topic is 6120 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.