• Thanks Lynn .. tried your CTE solution but it did not give the expected outcome .. i may concentrate on looking at a gridview templatefield solution.