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$),$