Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Rule for (Email Validation)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-28 : 08:40:44
Mano writes "Hi,

I am going to create user defined data type (for emailid) in SQL Server. and also i am going to create a Rule for email validation and bind it to user Defined Column (EmailID). What i want to how to give the Expression for rule (Email Validation).

Cau you any one help me?

Thanx
Mano"

jackstow
Posting Yak Master

160 Posts

Posted - 2002-01-28 : 12:06:18
Not sure if this is what you want but maybe something like

CREATE RULE email_rule
AS
@value LIKE '%@%.%'

...??


Jack

Go to Top of Page
   

- Advertisement -