We have a field called 'login_name', varchar 50 null.
I need to know which fields have any special characters but numbers are ok. - they should only have
their first initial and last name.
Some of them have the email address @/
but also some other special characters.
The data is supposed to be like this. For John Smith, = jsmith
But some staff may have jsmith@myworkcompany.org
or bad data. Bad data would be jsmith$, jsmith# etc.
but jsmith1 is good.