Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 16, 2000

Constraints on Social Security Number

Question:
How do I put a named constraint on a social security number defined as number(9) so that no hyphens are allowed in?

Answer:
To prevent numbers with hyphens from being entered into a SSN column, you can create a check constraint with this syntax:

([SSN] LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
If your front end puts the hyphens in the SSN, you can use a similar check constraint:
([SSN] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]') 
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date