length function in sql

SQL LEN() function is used to count the number or length of character in given string. It returns integer value always and null for empty string.