Limit SQL Server column to a list of possible values

you can use a CHECK constraint

ALTER TABLE <table>
ADD CONSTRAINT chk_val CHECK (col in ('yes','no','maybe'))

MSDN link