How do I script SQL constraint for a number to fall within a range?

Question

How to script a constraint on a field in a table, for an acceptable range of values is between 0 and 100?

Answer 1

ALTER TABLE Table
ADD CONSTRAINT CK_Table_Column_Range CHECK (
   Column >= 0 AND Column <= 100 --Inclusive
)

Answer 2

A check constraint like "fieldname BETWEEN 0 AND 100" should do it.