Table of ContentsPreviousNext

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


Ispirer SQLWays Database Migration Software

LEN

Syntax

LEN(string_expr)

LEN returns the number of characters of the giving string expression, excluding trailing blanks.

Example

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

SELECT CompanyName, LEN(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 94. Equivalents in other databases
IBM DB2
LENGTH function
Oracle
LENGTH 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.