CHAR_LENGTH clause

The
CHAR_LENGTH
 clause obtains the length of a
String
 type column.

Supported functionality

Examples of supported CHAR_LENGTH functionality
Expected behavior
Query to achieve the expected behavior
Calculate the length of a string in a column.
SELECT CHAR_LENGTH(Column1) AS Column1Length FROM Table1;
Filter rows where the string length is greater than 10.
SELECT * FROM Table1 WHERE CHAR_LENGTH(Column1) > 10;

Unsupported functionality

  • Using CHAR_LENGTH with non-string data types.
  • Combining CHAR_LENGTH with aggregate functions.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal