Data field

[IanT]

I have a field which contains data like:
DRAKES GRAPEFRUIT NAT JUIC
How can I remove the DRAKES from the data so I am left with:
GRAPEFRUIT NAT JUIC

Thanks in advance.........

 

[Mile-O]

UPDATE MyTable SET MyField = Mid$([MyField], InStr(1, [MyField], " ") + 1);