Comments on Microsoft Sql Server Tutorials: Validate Email Addresses in SQL Server

[Email] NOT LIKE '_%@%.%' [Email] LIK...

2011-09-08T12:13:00.742-07:00

[Email] NOT LIKE '_%@__%.__%'

[Email] LIKE '_%@__%.__%'

I wrote a script a while ago that finds bad format...

2010-11-22T03:52:28.696-08:00

I wrote a script a while ago that finds bad formats and human errors, then corrects them too.

Basically it cross references domains that have email opens recorded against them and corrects several human errors. So homail(missing character)/htomail(swapped character)/jotmail(close proximity keyboard button) are all corrected.

Details are too long to write here really so have a look at this link...

http://www.geakeit.co.uk/2010/07/30/the-ultimate-database-email-address-validatingprocessingcorrecting-script/

Madhivanan, Yes I know about this issue. Do you k...

2010-02-03T18:59:41.480-08:00

Madhivanan,

Yes I know about this issue. Do you know of a plugin that lets you format code with Live Writer?

Suprotim Isn't it possible to add code tag so...

2010-02-03T05:42:55.569-08:00

Suprotim

Isn't it possible to add code tag so that when we copy the code and paste in Query analyser they appear as they are instead of everything in a single line (which obviously need rework formatting the code)?

Madhivanan
http://beyondrelational.com/blogs/madhivanan

Comments on Microsoft Sql Server Tutorials: Validate Email Addresses in SQL Server

[Email] NOT LIKE '_%@__%.__%' [Email] LIK...

I wrote a script a while ago that finds bad format...

Madhivanan, Yes I know about this issue. Do you k...

Suprotim Isn't it possible to add code tag so...

[Email] NOT LIKE '_%@%.%' [Email] LIK...