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.

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.

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.

What are functions

3 Answers  

---

What is the difference between a check constraint and a rule?

0 Answers  

---

Questions on identity?

2 Answers   Infosys,

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

What are the advantages of using third-party tools?

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

How you can get the list of largest tables in a database?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---