hey mudassarkhan..thanx for replying..your post seems quite useful..i just want to check if its possible to do this without using stored procedures??because i'm not using stored procedures for my project.. :)