Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar(max) vs Varchar(400)
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 6.5 and older
Application:
Web
Miscellaneous
Thread ID:
01581593
Message ID:
01581716
Views:
71
>But given that an email address is only useful if it is valid, you need to at very least use a regex validation (this is true even for the 99% that only have one address.)
>

Only one caveat - regex on e-mail addresses - "thar be dragons!" - The rules around valid e-mail addresses are really complex. You want to err on the side of just basic sanity checking (has some text before the @, some text after the @ that includes a period); anything more probably won't work and you'll "fail" a perfectly valid e-mail address.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform