Can you differentiate between LEN() and DATALENGTH() in SQL?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Can you differentiate between LEN() and DATALENGTH() in SQL?
Question Posted on 05 Sep 2021

Home >> DataBase >> SQL Query >> Can you differentiate between LEN() and DATALENGTH() in SQL?

Can you differentiate between LEN() and DATALENGTH() in SQL?
LEN():- LEN() function will returns the length in characters which will exclude trailing spaces.
DATALENGTH():- DATALENGTH() function will only returns length of string in bytes and which will include trailing spaces below example will clarify you the details.

Datalength() and Len()

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

How to get the table count in last used query from cache by sending tablename?

Write a SQL query to print 1 to 100 in sql server?

Sql Interview Latest Query questions asked on 30 dec 2020

nth highest number from table

some good sql query

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)