Thank you for the idea. Do we have something in sql server to access any column using the index value like we do in c# or vb.

thanks..

Thanks for your time...but I have about 30columns of that kind so it is not feasible to create 30 store proc for each column.

any other idea? thank for your time.