if @email not like '[^.]%[^.]@[^.]%[^.].[^.]%[^.]'
or @email like '%[а-я `!#$%^&*(){}\|/,?]%'
or isnull(charindex('@', substring(@email, charindex('@', @email) + 1, len(@email) - charindex('@', @email))), 1) > 0
print 'Not valid'
else
print "valid'
Tuesday, October 9, 2007
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2007
(52)
-
▼
October
(30)
- Serp Archive
- Internet names for Asia launched
- MS SQL server: How to dynamically number rows in ...
- MS SQL server: E-mail address validation
- MS SQL server: How can I do a case-sensitive comp...
- MS SQL server: How to troubleshoot orphan users i...
- Eric Enge Interviews Google's Matt Cutts
- Goo.glicio.us - No more PageRank updates, Hello Pa...
- Corel Draw / Photo Paint Palette Generator
- VBScript: Capitalize String Function
- VBScript: URLDecode Function
- VBScript: URLEncode Function
- MS SQL server: Checking if a temporary table exists
- SQL Server: conversion from char to date error
- JavaScript: Doctype messing up script
- MS SQL server: Split up a string
- Connect to a .csv file via stored procedure in MS ...
- MS SQL server: How can I use the result set from ...
- MS SQL server: database marked as "suspect"
- MS SQL Future Keywords
- ODBC Reserved Keywords
- MS SQL Reserved keywords
- Optimizing SQL Server CPU Performance
- Scientists Invent 30 Year Continuous Power Laptop ...
- Report: Russia Evacuates Entire Bushehr Staff
- Welcome To The DMOZ Blog
- The most popular sites for domain names
- Google, Yahoo Sued For Stealing Names From Tanzani...
- CSS Layouts
- CSS Three Column Liquid Layout with Header and Footer
-
▼
October
(30)
No comments:
Post a Comment