CHARACTER_LENGTH Function Examples | Teradata Vantage - Examples - Analytics Database - Teradata Vantage

The following statement applies the CHARACTER_LENGTH function to the Name column, which is type VARCHAR(30) CHARACTER SET LATIN, to obtain the number of characters in each employee name:

   SELECT Name, CHARACTER_LENGTH(Name) 
   FROM Employee; 

The result is as follows (note that separator blanks are considered characters):

   Name      Character_Length(Name)
   --------  ----------------------
   Smith T            7
   Newman P           8
   Omura H            7
         .            .