Jason Shadonix (5/20/2009)
Interesting, I didn't know that.Just for fun I just created a dummy table with a VARCHAR column that I didn't specify the length for, and it made it of length 1.
That's expected for both CHAR and VARCHAR, according to the Books Online when the length is not given the default is 1 during definition and 30 when casting.
http://msdn.microsoft.com/en-us/library/aa258242(SQL.80).aspx