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