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]')