Thanks Everyone for the Response.

I got it.

Added to the above post.

I am using sql server 2005 and in that one table with values 5,6,7,9,1.

Note:- Feild data type is varchar.

Just I need the sum(5,6,7,9,1) = 28...