Hiya all,
I had this brilliant idea to cut down on the spam in our office - it works but if I don't put an 'allow' list in to our firewall I get all the spam by default!
We have hundreds of trusted email addresses on a database. Thing is I don't want the whole email address - just the domain.
I.e. myname@mycompany.co.uk just needs to become mycompany.co.uk.
My question: How do I just get the characters after the @
Any answer can be code or sql based and many thanks in advance for any advice!
Thank God it's Friday...
I had this brilliant idea to cut down on the spam in our office - it works but if I don't put an 'allow' list in to our firewall I get all the spam by default!
We have hundreds of trusted email addresses on a database. Thing is I don't want the whole email address - just the domain.
I.e. myname@mycompany.co.uk just needs to become mycompany.co.uk.
My question: How do I just get the characters after the @
Any answer can be code or sql based and many thanks in advance for any advice!
Thank God it's Friday...