Adding a non-empty constraint to Email field

Question

I have a varchar email field in my table. I can't figure out the syntax to add a constraint that ensures a non-empty value cannot be inserted. I"m not talking about not null, I'm talking not empty here.

Mehrdad Afshari · Accepted Answer · 2009-03-13 19:04:39Z

3

Add a not null and a check constraint.

create table MyTable (
   email varchar(100) not null,
   constraint email_not_empty check (rtrim(ltrim(email)) != '')
)

answered Mar 13, 2009 at 19:04

Mehrdad Afshari

424k93 gold badges864 silver badges796 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Darrel Miller Over a year ago

Why do you need to ltrim and rtrim? If it only contains whitespace then a single trim should reduce the length to zero, no?

Mehrdad Afshari Over a year ago

@Darrel: I don't think T-SQL supported TRIM.

Darrel Miller Over a year ago

No it doesn't but you could use either ltrim or rtrim and it should work.

jhale · Accepted Answer · 2009-03-13 19:04:57Z

0

len(ltrim(rtrim(email))) <> 0

answered Mar 13, 2009 at 19:04

jhale

1,8303 gold badges15 silver badges21 bronze badges

Collectives™ on Stack Overflow

Adding a non-empty constraint to Email field

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related