|
|
|
Junior Member
 
Group: Forum Members
Last Login: 2 days ago @ 11:11:58 AM
Posts: 22,
Visits: 88
|
|
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
Ince Chauke
Jnr BI System Analyst
Data Warehouse Department
Knowledge Leads The World.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 6/27/2008 7:19:28 AM
Posts: 42,
Visits: 54
|
|
Something like that :
select MAIL_ADDRESS || " is not valid"
from MY_TABLE
where MAIL_ADDRESS like any ('.%', '@%', '%.', '%@')
and MAIL_ADDRESS not like '%@%.%'
|
|
|
|