LENGTH

 

The function LENGTH returns the number of characters, excluding trailing blanks.

SQL Syntax:
 
   LENGTH( string )
Parameters:
 
  string

Any string or binary expression.

 

Escape Syntax:
 
  {fn LENGTH( number )}
Return Type:
 
  INT

Alternative Names:

  LEN, DATALENGTH This is the equivalent from the MS SQL Server.

Examples:

  • SELECT LENGTH( 'Peter' )

see also:
SQL String Functions


100% pure Java DBMS
Mirror Site