set column to only allow 2 options in sql code example

Example: how to permit only a few values in dbms

ALTER TABLE [TableName] ADD CONSTRAINT 
my_constraint CHECK (PatientType = 'Admitted' OR PatientType = 'OPD')