Constraint syntax

• tcronin 95651

  SSCertifiable

  Points: 6735

  More actions

  January 16, 2015 at 2:53 pm

  #397884

  Found out I could not do a rule so i need a constraint on a varchar(5) field that can contain null or up to 5 numbers including leading zeroes. What I tried is

  ALTER TABLE dbo.person_test2 ADD CONSTRAINT CK_ext

  check (Pext like '[0-9][0-9][0-9][0-9][0-9]')

  problem is it forces null and has to be 5 characters

• ScottPletcher

  SSC Guru

  Points: 100947

  More actions

  January 16, 2015 at 3:06 pm

  #1770913

  ALTER TABLE dbo.person_test2

  ADD CONSTRAINT CK_ext

  CHECK ( Pext LIKE REPLICATE('[0-9]', LEN(Pext)) )

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.