len / datalength - Jean-Nicolas BERGER

Hello,
Could someone explain those results, I don't understand the second one
regarding the others ...
Thx.
JN.

select len(0x4000),datalength(0x4000)
-- Result : 2 - 2
select len(0x4020),datalength(0x4020)
-- Result : 1 - 2
select len(0x4021),datalength(0x4021)
-- Result : 2 - 2

len / datalength - Russell Fields

Jean-Nicolas,

From the BOL definition of LEN:  Returns the number of characters, instead
of the number of bytes, of the given string expression, *** excluding
trailing blanks.***

Since 0x20 is a blank, the second selection for LEN(0x4020) only counts the
1 character 0x40.

RLF

len / datalength - Tom Cooper

Len() returns the number of characters, excluding any trailing blanks.
Since 0x20 is a blank, the value of Len(0x4020) is 1.  But DataLength()
returns the number of bytes including any trailing blanks.

Tom

len / datalength - SQL Menace

Run this for fun

Select LEN(' ') As LengthVarChar,
LEN(N' ') As LengthNVarChar,
DATALENGTH(' ') As DataLengthVarChar,
DATALENGTH(N' ') As DataLengthNVarChar


Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx



On May 8, 3:00=A0pm, "Jean-Nicolas BERGER" <j-n.enlevezmoi.ber...@club-