You 'll find this useful : Threaded discussions with SQL http://www.sqlteam.com/item.asp?ItemID=1602 hierarchies in sql (similar to celko style trees...) http://www.sqlteam.com/item.asp?ItemID=8866 ------ Ashok Hariharan http://www.unganisha.org ------