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.

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

explain extended properties

0 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

Explain mixed authentication mode of sql server?

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

How do I edit a stored procedure in sql server?

0 Answers  

---

what is a live lock? : Sql server database administration

0 Answers  

---

What are a scheduled jobs?

0 Answers  

---