Finding a Character in a string

[Mitch]

In excel I use the following funtion to located the "@"
character in an email address:
=FIND("@",A2,1) , where cell A2 contains the email address

The find function is not available in Access, is there
something else I can use?

 

[Rick Brandt]

In excel I use the following funtion to located the "@"
character in an email address:
=FIND("@",A2,1) , where cell A2 contains the email address

The find function is not available in Access, is there
something else I can use?

Check Help file for InStr() function.