Hi Gobi
Not sure if you meant how to define the table or query it But here is how
you would define it.
Create table accountnums(
row_id int not null identity(1,1) Primary Key,
acc_no varchar(6))
alter table accountnums add CONSTRAINT CK_acc_no CHECK (acc_no LIKE
'[A-Z][A-Z][0-9][0-9][0-9][0-9]')
insert accountnums(acc_no) values('aa1234') --OK
insert accountnums(acc_no) values('AA1234') -ok
insert accountnums(acc_no) values('A11234') --Generates error.
--
-Dick Christoph
"gobiparthi" <go*******@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
Dear friends,
If i want to specify the column name as "acc_no" then it
total size is 6 it must get the first two letters as alphapets and the
remaining 4 as numbers for this how to write the query?. Please reply.
By,
Gobi S.