What are the difference between data length and length in
SQL Server-2008?
- 3 Answers
- 5600 Views
- Scio Healthcare, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I create an extended event in sql server?
Explain full-text indexing?
How can I create a report based on a query? : sql server management studio
what is a schema in sql server 2005? : Sql server database administration
plss anybody specify tha constrian management system in dbms
Explain the functionalities that views support?
What are cursors stored procedures and triggers?
what's new in sql server 2016?
What is the difference between char, varchar and nvarchar?
What is sparse columns of sql server 2008?
How to maintain a fill factor in existing indexes?
What is built-in function?
Can you edit the .rdl code associated with a linked report?
What are sql server procedures?
What is meant by indexing?
