LEN Returns the number of characters, rather than the number of bytes, of

What are the difference between data length and length in
SQL Server-2008?

Question Posted / sapthagiri

3 Answers
6189 Views
Scio Healthcare, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of data sources?

935

Do you know what is openxml in sql server?

1015

Is it ok to shrink transaction log?

936

Where in ms sql server is ’100’ equal to ‘0’?

1018

How can we determine what objects a user-defined function depends upon?

950

Do you have any idea about the tcl commands?

910

How do you manipulate data?

849

How many database files are there in sql server 2000?what are they?

977

What are the different kinds of ssrs reports?

206

which table keeps the locking information? : Sql server administration

1011

How to provide login information for a new odbc dsn?

980

Do you know what is xpath?

1003

How does Report Builder support Analysis Services cubes?

147

How retrieve field names from the table in SQL through JAVA code?

1832

Comment,Datatypes are unlimited

2016