2.1.1.4 E021-04, CHARACTER_LENGTH function

  • Article

V0004:

The specification states the following:

 Subclause 6.28, "<numeric value function>":
  
 <char length expression> ::=
 { CHAR_LENGTH | CHARACTER_LENGTH } <left paren> <character value expression>
 [ USING <char length units> ] <right paren>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. See the LEN function [MSDN-LEN] for equivalent functionality. LEN accepts both the ASCII and Unicode character sets, but, unlike CHARACTER_LENGTH, excludes trailing blank characters.