LENGTH

LENGTH(s) returns the number of characters in string s.

 LENGTH('Hello') -> 5 

SELECT LENGTH(name), name
  FROM bbc

• SUBSTRING function
• || (concatenate) operation