What are the difference between data length and length in
SQL Server-2008?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Does table partitioning improve performance?
Will count(column) include columns with null values in its count?
Explain stored procedure?
What are explicit and implicit transactions?
How to update muliple row in single query?
In which tcp/ip port does sql server run? Can it be changed?
Define indexes?
What is GUID in sql server?
What are the benefits of normalization?
What are the source of constraints?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is the use of tempdb? What values does it hold?