Re: plz suggest me the query

CREATE TABLE [dbo].[Departments](
[DepartmentID] [nchar](6) NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Departments] WITH CHECK ADD CONSTRAINT
[CK_Departments] CHECK (([DepartmentID] like 'DEP[0-9][0-9][0-9]'))
GO

ALTER TABLE [dbo].[Departments] CHECK CONSTRAINT [CK_Departments]
GO
.