what I would simply do but
may be tricky for you is

take the data from that table
and paste it into excel.

once in excel you can use
formulas to strip down the
data in the cell.

then you can take the data
from the excel table/spread-
sheet back into that access
table.

or link access to that excel
table.

if you have never used excel
to modify data in access tables,

then it would be something
worthwhile to learn because
it is highly handy.

also be sure to make a couple
of backups/copes of your
original access database
before

--
--
db·´¯`·...¸)))º

DatabaseBen, Retired Professional

~~~~~~~~~~~~~~~
This NNTP newsgroup is evolving to:

http://answers.microsoft.com/en-us/default.aspx


"Rezzell" wrote in message
...
I have an access database that has a bunch of email addresses in it. I
want
to strip it down to just the username. What criteria will I use in my
update
query to get the desired results. I want to take and strip the
@bob.com off to make it just joe. Any thoughts?