| Difference between LEN() and DATALENGTH() in sql server
LEN() will give you how many character are present there in any of the datatype or we can say it return the length of the string by using Len keyword.
DATALENGTH() will gives you the number of bytes that are used to store value. | | |