Table of ContentsPreviousNext

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 Oracle to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software




The LENGTH function returns the length of a value. The argument can be an expression that returns a value of any built-in data type.

If the argument is a string, the function returns the number of characters in the string. The length of fixed-length strings includes blanks. The length of a varying-length string is the actual length, not the maximum length.


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

SELECT CompanyName, LENGTH(CompanyName)
Here is the result set: 
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 78. Equivalents in other databases
LENGTH function
Microsoft SQL Server
LEN function

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