I have a table with 500 rows and the name field is like this:
Dr. Zvi Ben-Zvi
Dr. Zova Liu
I know how to get just the last name with a mid query, but trying to do a left and all I end up with is Dr. portion. This is the code I am using but it is not right because I want the first name as:
Dr. Zvi
Dr. Zova
Code:Left([pcp],(InStr(1,[pcp]," "))-1)