Limiting Values

• deek

  SSCommitted

  Points: 1886

  More actions

  March 20, 2002 at 6:32 pm

  #78274

  Is there a way to restrict the values in a field to a specific two or three?

  I have a field where I want the only allowable values to be "A", "I", and "U".

  Thanks

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 20, 2002 at 7:33 pm

  #425768

  Do this with a check constraint. Ex.

  ALTER TABLE tableX WITH NOCHECK

  ADD CONSTRAINT limitvalue CHECK (columnx IN ('A','I','U')

  If you want to have check table at creation chnage NOCHECK to CHECK

  See BOL for more help.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)