How to get the number of characters occupied in particular column

[siva125]

I use this query for my table but it retrives the value for each row. It does not retrieve the size of the column name. I need to know the number of characters occupied in particular column. How do i get this value?

SELECT LEN(salary) AS MyLength FROM employee

[ThatThatGuy]

Extending your query a bit..

SELECT LEN(salary) AS MyLength FROM employee GROUP BY salary
 

[siva125]

@ThatThatGuy
hi,
i need the columnname salary varchar (i.e) size of that field

[ThatThatGuy]

@siva125

select sc.[length] from sysobjects so inner join syscolumns sc on so.id=sc.id where so.[name]='<table_name>' and sc.[name]='<column_name>'

this will do

but make sure the correct database is selected