How to get the length of string 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.