Len() vs datalength() in SQL Server 2005 September 17, 2023 by Tarik Be careful. DATALENGTH returns the number of bytes used, not the number of characters.