"Limit to List" equivalent in SQL

In Access, I can limit field options to a list. What is the equivalent in SQL 2005?use a lookup table and enforce referential integrity.|||well, if it's a limited set, with ~0 likelihood of needing to be updated, you can also use a CHECK constraint

for examplecreate table foo
( ...
, gender char(1) null check (coalesce(gender,'M') in ('M','F'))
... )