CHAR_LENGTH

version 11

CHAR_LENGTH (arithmetic_expression)

The CHAR_LENGTH function returns the number of characters in the arithmetic_expression.

This example returns the number of characters in the name of products where the weight is less than 15 lbs.

   SELECT CHAR_LENGTH (Name)
   FROM PRODUCTS 
   WHERE Weight < 15.00

LENGTH.