| 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.
| | |