Querying part data

[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

 

[Tom Lake]

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 '@'

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

if the field Domain is

(e-mail address removed)

the Mid$ above will give you

here.com


Tom Lake