find length of field [Resolved]

Posted by Oswaldlily under ASP.NET on 8/8/2011 | Points: 10 | Views : 1054 | Status : [Member] | Replies : 1
I ve column A and B

Column A has some strings.
column B need to find the length of column A
and that shd be display in gridview....what are possible ways




Responses

Posted by: Nithadeepak on: 8/8/2011 [Member] Bronze | Points: 50

Up
0
Down

Resolved
SELECT A, LEN(A) B FROM Table-Name;

For more refer...
http://www.1keydata.com/sql/sql-length.html
http://danpowers.hubpages.com/hub/How-to-find-the-length-of-a-string-in-SQL-Server

Then bind it to the gridview.

Nitha Deepak

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response