create email address

[jmhicsupt]

I have employee's name in one field. The field is displayed as doe, john. I now need to display the field as john.doe.

How would I do this?

Thanks in advance.

 

[PHV]

You may try to use the Replace function:
Replace([employee's name field], ', ', '.')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Melagan]

doe, john to john.doe:

SELECT t.name
, mid(t.[name], Instr(t.[name], ",")+2) & "." & left(t.[name], Instr(t.[name], ",")-1) as NewName

FROM tblYourtable as t

~Melagan
______
"It's never too late to become what you might have been.

 

[PHV]

OOps, sorry, missed the FirstName LastName inversion ...

 

[Melagan]

No worries PH - I only applied what I learned from your posts to answer the question in the first place!

~Melagan
______
"It's never too late to become what you might have been.