InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:58:18 GMT20http://www.teradata.com/teradataforum/Topic11904-9-1.aspxSomething like that : select MAIL_ADDRESS || " is not valid"from MY_TABLEwhere MAIL_ADDRESS like any ('.%', '@%', '%.', '%@') and MAIL_ADDRESS not like '%@%.%'Wed, 18 Jun 2008 12:32:12 GMTal1_24http://www.teradata.com/teradataforum/Topic11904-9-1.aspxHiDoes 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,InceTue, 17 Jun 2008 09:03:50 GMTInce