MS Access Validaiton rule in SQL Server

[emsik1001]

Hi Everyone

I have a very very basic question.... I would like to do 'validation rule' in SQL Server the same as I can do in MS Access. More precisely I would like Score INT field to be between 1 and 5 only.

How can I do that in SQL Server 2005?

Many thanks in advance
Emil

[ck9663]

Create a DOMAIN CHECK CONSTRAINT

Good Luck!!!

~~ CK