Removing "," between First & Last Names

[Fran]

I have the following data in a field called "named":
John,Smith
Bob, Davis
Juli, Orr

I would like to remove the "," between the first and last
name. In the example above the first name is "John" and
the last name is "Smith".

How can I do this using Access 2002.


Thanks

 

[Fredg]

Look up the Replace function in Access help
Exp:Replace([Fieldname],",","")