Replace text from a specific character

[Sheila D]

I foolishly changed my text field to a hyperlink and then changed it back
again and now all my e-mail addresses show as e.g.
[email protected]#mailto[email protected]
I can recover most of them from my backup but wondered if there is a way of
using the update query to remove everything from the # onwards.
Thanks for any help
Sheila

 

[Pieter Wijnen]

Update MyTable
Set MyField = Left([MyField], Instr([MyField],'#')-1)

Ought to do it

Pieter

 

[Sheila D]

Fantastic, worked a treat, thanks

Update MyTable
Set MyField = Left([MyField], Instr([MyField],'#')-1)

Ought to do it

Pieter

I foolishly changed my text field to a hyperlink and then changed it back
again and now all my e-mail addresses show as e.g.
[email protected]#mailto[email protected]
I can recover most of them from my backup but wondered if there is a way
of
using the update query to remove everything from the # onwards.
Thanks for any help
Sheila