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 |
What are binary string data types in ms sql server?
How do SQL server 2000 and XML linked?
What is data modification?
How many triggers are possible per table?
What is exporting utility?
What is sql server schema compare? How we can compare two database schemas?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are window functions in sql server?
Explain the difference between control flow and data flow?
How to create new tables with "select ... Into" statements in ms sql server?
How to choose all records from the table?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?