IowaDave (7/11/2012)
Why does datalength of nchar(40) give 80?!?? That really threw me.Thanks!
Because it is the entire length of the string * 2 bytes. Nchar includes padding so the length is 40 versus 7 with nvarchar which does not include padding.