Email Validation

Database
Enthusiast

Email Validation

Hi

Does someone knows how to validate an email using Teradata SQL, the email must not be null,and must not start with a @, '." symbols, and must not end with these symbols as well.

I will really appreciate it if some one can help, its easier using MS SQL Functions,but I cannot implement such funtion in Teradata(not supported by my environment).

Regards,
Ince
1 REPLY
Enthusiast

Re: Email Validation

Something like that :
select MAIL_ADDRESS || " is not valid"
from MY_TABLE
where MAIL_ADDRESS like any ('.%', '@%', '%.', '%@')
and MAIL_ADDRESS not like '%@%.%'