On Wed, 6 Mar 2002, Joseph Maxwell wrote:
> Hello,
> I have created a DB and TABLE but would like to constrain one field to
> accept either "YES" or "NO" only. How can I set this up?
Probably something like:
Prior_Rx varchar(3) CHECK (Prior_Rx in ('Yes','No'))