Text String Queries

[bry2k]

Hello,

Please can you help with a query I am trying to write.

I have a list of email addresses for clients e.g. "[email protected]", I wish to
create a query that will leave the domain name leaving "name.com".

Any assistance is gratefully received.

Regards,

Bry2k

 

[TedMi]

Check VBA help for the functions Instr and Right$.
You can use the first to find the location of "@" in the address, then Right
to return the appropriate no. of characters from the end of the string.

 

[John Vinson]

Hello,

Please can you help with a query I am trying to write.

I have a list of email addresses for clients e.g. "[email protected]", I wish to
create a query that will leave the domain name leaving "name.com".

SELECT Mid(, InStr([EMail], "@") + 1),
<any other fields you want to see>
FROM yourtable;

John W. Vinson[MVP]

 

[Bry2k]

Hello,

Thank you very much for your help.

Merry Christmas.

Regards,

Bry2k