hi,

I am a newbie in filed of DBa. Can anyone plz explain me how the 41,80 coming while executing--

DECLARE @nvarchar nvarchar(40)

DECLARE @nchar nchar(40)

SET @nvarchar = '7 chars'

SET @nchar = '7 chars'

SELECT len(@nvarchar), len(@nchar),

len(@nvarchar+';'), len(@nchar+';'),

datalength(@nvarchar), datalength(@nchar)

Correct answer:

7,7,8,41,14,80

thanks a lot in advance