Mikael, thanks. Just before you...

Mikael Eriksson SE (10/17/2013)

---

It is the same in SQL Server 2005, 2008 and 2012.

If you want to check what the compiled value is you can use this.

create table T(Name varchar(25));

go

create...

Excellent question. I did get it wrong (most from not paying enough attention...I was in the "Pelle, Pelle" group), but excellent question nevertheless. While I know you did...

All:

Thank you for your responses. I thought an easy one for Friday would be fun and since a lot of "DBA's" (logical\physical\both) have issues with data\field storage, this would...

Carlo

You are correct in your statement. However, just wanted to give an easy overview explanation to the answer. I could have gone "real deep" in the explanation, but...