convert name field into lname,fname, mname

[jpwcyc]

In Access 97. I am trying to parse name field into three fields. For the most part data is in this format in the name field.<br>
<br>
Smith, John P<br>
<br>
The table has 26000 records. Iknow there are some variations. I think I have seen records where there is 2 spaces between the comma and first name. some do not have middle names or initials.<br>
<br>

 

[calahans]

Have you tried to use the instr function<br>
this function gives you the charcter position of the character you are looking for<br>
<br>
instr(0,yourstring,&quot; &quot i.e. look for the first space from position zero.<br>
<br>
HTH<br>
<br>
C