Copying only part of data from a text field

[davedejonge]

Hi, I have a table that has contatct info, one field includes first names of contacts, I want to pull out just the first name from that field.. (eg would be, the field would contain "john and sue" sometimes it might just say "bill") I want to update a new field with the first names.
I know how to use left(table.field),1,x but, how can I tell it to look for a space rather than a number of characters???

thanks



Dave

[RuralGuy]

Have you looked at the InStr() function yet?