Check:

Check limits the values that are accepted by one or more columns.

The Below code accepts only values A or k or R or S, it will not accept other than this.

USE Rohan

GO

CREATE TABLE CHEECK (ID INT, SHORT VARCHAR(2) CHECK (SHORT LIKE '[A,K,R,S]'))

Thanks,

Rohan k

UsefulSite:

CheckConstraint