Access string functions like MS SQL "seek"

OK- I have been shown the correct method to accomplish the split, but not the format that Access understands?

<cfquery name="updatedata" datasource="#Request.BaseDSN#">


UPDATE lookup_requestor n
INNER JOIN

lookup_customers o ON o.BidID = n.old_bid_ID
SET

n.requestor_lname = right(ContactName,seek(ContactName,' ')),
n.requestor_fname = left(ContactName,seek(ContactName,' '))

</cfquery>

Extract first and last names - any advice?

This must have to do with formatting, [ vs ( or "", ' etc.?

Thanks.