What function do you use to find an embedded space in a field 1

[drosenkranz]

I have a table given to me with a name field that contains a last name and the first name in the same field with only a space between them. Ex: Smith Joe

I want to replace the space with a comma and a space so the name would look more like Smith, Joe

What function would I use to search the field and return the position of the embedded space so I can concatenate the name the way I want it?

Thanks
The 2nd mouse gets the cheese.

 

[JerryDennison]

InStr([FieldName], " &quot

 

[scking]

Rather than using a function like instr you may want to consider the ease of opening the table, selecting the column, and using the edit/replace capability. I know it's low tech but your tables are immediately compliant and you don't have to mess around building, testing, and using the function.

Steve King