Hi

Lowell solution is right solution, so this way you are hard coding the column names any where in the query. This is so dynamic.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com