Querying part data

A

Alex H

Hi -
I have two list sof email addresses and I need to run an Unmatched query to
select from the first list all records where there is no match on the email
domain (ie everything after the '@'sign in the email address) .

Could some kind person advise me how I select the string from the '@'

Thanks
 
T

Tom Lake

Alex H said:
Hi -
I have two list sof email addresses and I need to run an Unmatched query
to select from the first list all records where there is no match on the
email domain (ie everything after the '@'sign in the email address) .

Could some kind person advise me how I select the string from the '@'
Click to expand...


Mid$([Domain], Instr([Domain], "@") + 1)

if the field Domain is

[email protected]

the Mid$ above will give you

here.com


Tom Lake
 
Top