Separate name field (2002/sp3)

Topic

New Reply

I have a name field that has names in this format Smith;Tom

How do I convert the names in a query into a new field that looks like Smith; Tom

Thanks.

Paul

Reply | Quote

Replies

Say that the field is called TheName. The following expression will insert a space after the semicolon:

Replace([TheName],";","; ")

BTW, I’d prefer to store the name in separate FirstName and LastName fields in the table. It’s easy to concatenate these fields for presentation purposes.

Reply | Quote