Constraints

Hi,
How do I create a Constraints for a table column.
I want to limit the user to enter a W or an S how can I do that?
Thanks
DibYou want a CHECK constraint. You can create a check constraint using the
ALTER TABLE statement, or from Enterprise Manager. See the topic Creating
and Modifying CHECK Constraints in Books Online for details.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Dib" <dNOSPAMshahene@.conNOSPAMsoftware.com> wrote in message
news:e1bbC8fOFHA.3376@.TK2MSFTNGP09.phx.gbl...
> Hi,
> How do I create a Constraints for a table column.
> I want to limit the user to enter a W or an S how can I do that?
> Thanks
> Dib
>