CODEWITHSUNDEEP
sqlsql-servert-sqlcheck-constraints
Jake Petroules
Jake Petroules

Reputation: 24150

How can I create a CHECK constraint on a VARCHAR column in SQL Server specifying a minimum data length?

I have a VARCHAR(30) column in a Microsoft SQL Server database. I'd like to add a CHECK constraint that does not allow a value in the column to be less than 3 characters. What is the expression I must use?

Upvotes: 19

Views: 32531

Answers (1)

OMG Ponies
OMG Ponies

Reputation: 332571

use:

ALTER TABLE [dbo].[YOUR_TABLE]
ADD CONSTRAINT [MinLengthConstraint] CHECK (DATALENGTH([your_column]) > 2)

Reference:

Upvotes: 30

Related Questions