LEN

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

 LEN('Hello') -> 5 

SELECT LEN(name), name
  FROM bbc

• SUBSTRING function
• || (concatenate) operation