Changing Values

[adamjblakey]

Hi,

I have a table with email address's in and they are in this format: mail@email. com and i want them to be in this format: mail@email.com is there a statement that could achieve this or not?

Cheers,
Adam

[ronverdonk]

Maybe it's not my day, but I cannot see the difference between the 2 formats you show.

Ronald