len

Returns the number of characters, not the number of bytes, of a specified string expression, excluding trailing blanks.

Syntax

len(string_expression)

Parameters

Examples

Usage

This function is the equivalent of char_length(string_expression).

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute len.

Related concepts
Transact-SQL Functions
Related reference
char_length
left
str_replace