Hai,U want to display top 10, with my knowledge we can do it in 2 ways1. is using TOP keyword in sql (which u already tried)2. is using record set propertyby using option 2 we can restrict the record set to read n records. Just go thru record set properties, since i forget the syntax.Bye,Vamsy