Thursday, 21 April 2011

The LEN() Function


 The LEN() function returns the length of the value in a text field.

SQL LEN() Syntax
SELECT LEN(column_name) FROM table_name

The "custmast" Table 
custcode
custname
city
qty
rate
1
Siva
Srivilliputtur
50
70
2
Bala
Sivakasi
30
56
3
Kanna
Madurai
100
200
4
Vijay
Chennai
30
30
5
Kodee
Sandnes
60
80
5
Kodee
Srivilliputtur
60
30

Example : 
SELECT LEN(City) as LengthOfCity FROM Custmast

LengthOfCity
        14
         8
         7
         7
        7
     14

 Share This Post


Friendly Learn Translate to Tamil

Smilely

Services

© 2014