extracting information before a comma in a field

  • Thread starter Thread starter bird lover
  • Start date Start date
B

bird lover

I am a non-programmer working in access 2003. I have the following in field
[address]
750-44 Oakland St, Islip (Town, Outside Of Villages), NY

I want to run a query that will look for the first comma and take the
preceding data and put it into field [street]. In the above example, 750-44
Oakland St will be placed into the street field. A sample syntax would be
appreciated that I could stick in an update query.
 
Back
Top