Delete first 3 or 4 characters in a field

I am doing a simple query and I need to delete the first 3 or 4 characters in the field.  Examples of the field would be:  

1. Alex Smith  
12. Aaron Rodgers

I only want the name, not the numbers or period.
I think I have done this before with the InStr function.
Scott PalmerData AnalystAsked:
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
run an update query, assuming the name of field is [Name]

update tableName
set [Name]= Trim(Mid([Name],Instr([name],".")+1))
where [Name] is not null
Scott PalmerData AnalystAuthor Commented:
Thanks Cap
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.