Removing all characters after a certain point in a text field 1

[CuckooNut]

Hi everyone,

I have an Email field in my table that I converted from a Hyperlink field into a text field, and now all of the email addresses are concatenated with "#mailto:[the person's email address]". I need to delete everything from "#mailto" to the end of the string. I could go through and do it manually, but that would be very time consuming, so I am wondering if there is a way to do this through a query or using VBA.

Any thoughts?

Thanks!

 

[PWise]

how about
update table
set email=left(email,instr(email,"#mailto:")-1)

 

[CuckooNut]

Worked perfectly. Thanks!