LENGTH

All functions > STRING > LENGTH

Returns the number of characters in a string.

Syntax

LENGTH(expr)
sql

Arguments

ParameterTypeRequiredDescription
stringVARCHARYesInput string to measure

Returns

Number of characters in the string

Notes

  • Counts characters, not bytes
  • Spaces and special characters are counted
  • Unicode characters (emoji, symbols) count as single characters
  • Aliases: LEN, SIZE

Aliases

  • LEN

  • SIZE

Examples

Suggest changes to this page
Last update at: 2025/11/06 07:00:15
Last updated: 2025-11-06 07:00:51