Difference between Length() and DataLength()?

Syedshakeer
Posted by Syedshakeer under Sql Server category on | Views : 1620
Difference between Length() and DataLength() ?
Len():-
Length function return the number of Characters of the specified string expression,excluding blank spaces.

select Len ('inthiyaaz ') as length

OutPut:-
length
9
DataLenght():-
DataLength function return the number of Characters of the specified string expression,including blank spaces.

select datalength ('inthiyaaz ') as length
OutPut:-
length
11

Comments or Responses

Login to post response