Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

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


No comments:
Write comments

Infolinks

Services

© 2014