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( )
 representation of length function in sql
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

Related Searches to Length Function in SQL