Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

LENGTH

Syntax

LENGTH(string_expr)

LENGTH returns the number of characters of the giving string expression.

Example

This example returns the company name and the number of characters in the name for each company. 

SELECT CompanyName, LENGTH(CompanyName)
FROM CUSTOMERS

Here is the result set: 
CompanyName   
_______________________________
Consolidated Holdings       	 21
Eastern Connection           	18
France restauration          	19
Great Lakes Food Market      	23
Island Trading               	14
Let's Stop N Shop            	17

Equivalents in other databases

TABLE 82. Equivalents in other databases
IBM DB2
LENGTH function
Microsoft SQL Server
LEN function

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.