LEFT or MID or RIGHT functions

[joeypbbwcdf]

Please help!! I've got a table that was imported from Excel. The Name field in the table has the following format: Last Name, First Name. I need a query that will trim the last name up to the comma so that I can populate a new field last name only. I can use the LEFT, MID and RIGHT functions when I define the number of characters that I want but I don't know how to go LEFT until I reach the comma. Can anyone help?

 

[Mile-O]

Use them in conjunction with the InStr() function.