Translate to Tamil

Earn Money


Best Offers

Amazon Best Offers

Offers

Best Online Offers

Amazon Offers

Earn Money Short URL

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

Contact Form

Name

Email *

Message *

Infolinks

© 2014