Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer DB2 to SQL Server Migration overview.

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