I am trying to make a check constraint for a social security number:
alter table student
add constraint ssn_cons check(s_id like
"[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]")

but it keeps blowing up:

Server: Msg 1759, Level 16, State 1, Line 1
Invalid column '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]' is
specified in a constraint or computed-column definition.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.
--
Any ideas?
Thanks in advance.
Chris

Report this post to a moderator

Simply use single quotes ' around the check constraint instead of double
quotes "


"chris" <chris@fin2000.com> wrote in message
news:eR9G9uedCHA.2504@tkmsftngp09...
> I am trying to make a check constraint for a social security number:
> alter table student
> add constraint ssn_cons check(s_id like
> "[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]")
>
> but it keeps blowing up:
>
> Server: Msg 1759, Level 16, State 1, Line 1
> Invalid column '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]' is
> specified in a constraint or computed-column definition.
> Server: Msg 1750, Level 16, State 1, Line 1
> Could not create constraint. See previous errors.
> --
> Any ideas?
> Thanks in advance.
> Chris
>
>

Report this post to a moderator