Hi. Sorry if this is an old question, but....

i have a table that includes an e-mail address

in a query, i would like to create two columns with expressions for
the hostname and the username.

what function(s) would i use to split the e-mail address to what comes
before the @ and what comes after?

thanks,

Larry
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

Try Instr() to find location of the @ symbol in the email address, then
Left() and Right() to extract the text
eg.

Assuming @ will always exist.....

username = Left([myEmail], InStr("@", [myEmail])-1)
hostname = Right([myEmail], Len([myEmail]) - Instr("@", [myEmail])

Or something like that!
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"bender" <larry@netgeexdotcom> wrote