Ok I will try and let u know the result.....

any other solution?

Thanks,

Barath.

Is it possible through the syscolumns table?

Thanks for the solution....

but this one is the lengthy process right .If i have more than that no of col's?

Can u give me a query for dynamic pupose....

any way thanks...