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 is named query? : sql server analysis services, ssas

0 Answers  

---

What is cdc in sql server?

0 Answers  

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

How do you send email on SQL Server?

0 Answers   MindCracker,

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

---

What are “lost updates”?

0 Answers  

---