using the RIGHT / FIND function in Access Query 1

[RandDUser]

I have a field in an Access 2000 query that are email addresses. I am trying to define another field in the query to return the text after the '@'. Here is what I wrote...

Email Provider: Right([EMAIL_ADDR],Len(([EMAIL_ADDR])-FIND("@",[EMAIL_ADDR])))

The problem is that Access does not recongnize the FIND function.

Any suggestions?

Thank you!

 

[Remou]

I think you need InStr:
Right([EMAIL_ADDR], Len([EMAIL_ADDR]) - InStr([EMAIL_ADDR], "@"))

 

[RandDUser]

That worked perfectly, thank you!

 

[PHV]

A simpler way:
Email Provider: Mid([EMAIL_ADDR], 1+InStr([EMAIL_ADDR],'@'))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886