What are the difference between data length and length in SQL Server-2008?

What are the difference between data length and length in
SQL Server-2008?

Question Posted / surendar.k

3 Answers
6226 Views
Scio Healthcare, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the difference between data length and length in SQL Server-2008?..

Answer / sapthagiri

LEN
Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks.

DATALENGTH
Returns the number of bytes used to represent any expression.

Is This Answer Correct ?

2 Yes

0 No

What are the difference between data length and length in SQL Server-2008?..

Answer / bindu

The DATALENGTH function counts both trailing spaces and preceeding spaces when calculating the length of the expression.
The DATALENGTH function will return NULL, if the expression is NULL.

The LEN function does NOT count trailing spaces at the end of the string when calculating the length of the string.
The LEN function does count spaces at the start of the string when calculating the length of the string.
The LEN function will return NULL, if the string is NULL.

Is This Answer Correct ?

2 Yes

0 No

What are the difference between data length and length in SQL Server-2008?..

Answer / rajkumar

If the string has the space before the like
select LEN(' raj')
select dataLENgth(' raj')
Both consider the space.

but space is after the string len is not bother about space it wil be trucated.

datalenth counted with space.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer