DATALENGTH function returns string length in bytes:
DECLARE @str VARCHAR(10)
SET @str= ' '
PRINT LEN(@str)
PRINT DATALENGTH(@str)
Result:
0
6
DATALENGTH function returns string length in bytes:
DECLARE @str VARCHAR(10)
SET @str= ' '
PRINT LEN(@str)
PRINT DATALENGTH(@str)
Result:
0
6