add check constarint on

CREATE$$TABLE$$Customer

$($ CustNo$$CHAR$(8),$

CustFirstName VARCHAR$2(20)$CONSTRAINT$$CustFirstNameRequired$$NOT$$NULL$,$

CustLastName VARCHAR$2(30)$CONSTRAINT$$CustLastNameRequired$$NOT$$NULL$,$

CustStreet VARCHAR$2(50),$

CustCity VARCHAR$2(30),$

CustState$$CHAR$(2)$CONSTRAINT$$Customer$\_$CustState$$CHECK$($CustState$$IN$(\text{'}$CO$\text{'},\text{'}$CA$\text{'},\text{'}$WA$\text{'},\text{'}$AZ$\text{'},\text{'}$UT$\text{'},\text{'}$NV$\text{'},\text{'}$ID$\text{'},\text{'}$OR$\text{'})),$

CustZip$$CHAR$(10),$

CustBal$$DECIMAL$(12,2)$DEFAULT$0,$

CONSTRAINT$$PKCustomer$$PRIMARY$$KEY $($CustNo$),$