Separating Text In An Email Address

[wahamler]

I have a field that contains email address in standard format
([email protected]). I need to pull the handle out of that string.

Is their an update query I can run to do this?

 

[Allen Browne]

Use Instr() to locate the "@" in the string.

Use Left() to get the preceding characters, or Mid() for the later ones.