hiii,thanks
table abc
columnname-- status.
status should be like this

A-ADMINISTRATOR
S-STAFF
E-EXPIRED
S-SUSPEND
Above values should be valid by using "check" constraint.

any one give me syntax
thanks