LENGTH

How can we measure character count in text columns?

Advanced⏱ 3 Minutes⭐ 1490 XP

🤔 THE QUESTION

How can we measure character count in text columns?

💡 WHAT IS IT?

LENGTH() returns the number of characters in a string value.

🎯 WHAT IS IT USED FOR?

Data validation, checking password length, detecting truncation in ETL ingestion.

💻 EXAMPLE

SELECT
name,
LENGTH(name) AS name_length
FROM employees;

Practice typing production-grade SQL code for LENGTH.