Check Constraint Help

[Sherin Mathew]

Can i create Custom check constraint in SQL Server?

I have a table 'City' having columns as 'ID' , 'Name' and 'Number'.
If Name is 'AA' then Number column shouldn't accept null values. If name is other than 'AA' Number column can be null

[Swastik Dey]

Does this solve your purpose

create table test (id varchar(10) primary key,name varchar(10),number varchar(10) CONSTRAINT MY_CONSTRAINT CHECK(
        CASE 
            WHEN NAME = 'AA' 
                THEN NUMBER NOT NULL            
        END))