SQL LEN () function Instance Tutorial

SQL LEN () function Instance Tutorial

In Len () function
The Len () function returns the value of the length in the text field.

Database Len () syntax

SELECT LEN (column_name) from table_name

Let's take a look at an example.

 
   
    Address 
       City 
     

  
    
    
 
     
 
      
Id
 
      
LastName
 
      
FirstName
 
      
 
     
 
      
1
 
      
Hansen
 
      
Ola
 
      
TIMOTEIVN 10
 
      
Sandnes
 
     
 
     
 
      
2
 
      
Svendson
 
      
Tove
 
      
BORGVN 23
 
      
Sandnes
 
     
 
     
 
      
3
 
      
Pettersen
 
      
Kari
 
      
STORGT 20
 
      
Stavanger
 
     
 
    
 
   
   

Here we take the following SQL statement.

 
 SELECT LEN (address) as lengthofaddress from Persons 
 
   
 
 output results. 
   
 
 
    
    
 
     
     
 
      
 
       
l Engthofaddress 
 
      
 
      
 
       
 
 
      
 
      
 
       
 9