Can you differentiate between LEN() and DATALENGTH() in SQL?

1.	Can you differentiate between LEN() and DATALENGTH() in SQL?
Answer» Can you differentiate between LEN() and DATALENGTH() in SQL? LEN():- LEN() FUNCTION will RETURNS the length in characters which will EXCLUDE trailing spaces. DATALENGTH():- DATALENGTH() function will only returns length of string in bytes and which will include trailing spaces below example will clarify you the details.

Discussion