Length SQL | Length Function in SQL - sql - sql tutorial - learn sql

• The Length function in SQL is used to get the length of a string. This function has a different name for different databases:
• MySQL : LENGTH( )
• Oracle : LENGTH( )
• SQL Server: LEN( )

Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

Syntax

• The syntax for the Length function is as follows:

Length (str)

• The length of the string str is returned.

Examples

• We use the following table for our examples.

Table Geography

Region_Name	Store_Name
East	Boston
East	New York
West	Los Angeles
West	San Diego

Example 1

SELECT Length (Store_Name) 
FROM Geography 
WHERE Store_Name = 'Los Angeles';

Result:

Length (Store_Name)
11

Example 2

SELECT Region_Name, Length (Region_Name) 
FROM Geography;

Result:

Region_Name	Length (Region_Name)
East	4
East	4
West	4
West	4

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf