A quick question, I'm trying to identify relevant email addresses from a table. So far I've got the following in the where clause:
where email is not NULL
and email like ('%@%')
But does anyone know how I could get rid of spaces (if they occur) in the email field. For example 745856 @usa.net, should actually read as firstname.lastname@example.org....