检查约束(check constraint)

 嗨我想在sql server中添加约束我尝试这个但不工作我需要检查一个单词2 char和3个数字后面的例子aa192： 
 
create table test(
    idtest int primary key ,
    neEdition varchar(50)
);

alter table test add constraint ch_like check(neEdition like'[a-z][a-z][0-9][0-9][0-9]');

hi i want add constraint in sql server i try this but not work i needd check if a word 2 char and 3 numbers after example aa192:
 
create table test(
    idtest int primary key ,
    neEdition varchar(50)
);

alter table test add constraint ch_like check(neEdition like'[a-z][a-z][0-9][0-9][0-9]');

原文：https://stackoverflow.com/questions/46253857