function regular expression to validate email

• Terry-380449

  Default port

  Points: 1458

  More actions

  November 29, 2007 at 10:35 am

  #181820

  Hello

  Anyone has a function with maybe with regular expression, that i can call in SSIS in order to verify the email address before inserting into the database?

  One of the rule could be to verify at least that the adress should be in the format a@b.c

  What other rules could there be? smthg that checks the domain names etc...

  thanks!

• Ravi Patel-554358

  SSC-Addicted

  Points: 471

  More actions

  November 29, 2007 at 11:37 am

  #755593

  http://blogs.msdn.com/sqlclr/archive/2005/06/29/regex.aspx

  Go there.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 29, 2007 at 11:49 am

  #755605

  Or try this one:

  http://vyaskn.tripod.com/handling_email_addresses_in_sql_server.htm

  [font="Verdana"]Markus Bohse[/font]