Your best bet is to maintain this information in separate content table (like your file system does). When you occupy a block, you go and update your content table. This way you can allways select MAX() and have the largest block. You can certainly write some complicated sql statement to do so as well, however if there are lots of shelves your query will take forever.
Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Bhupesh Gupta Newsgroups: public.remedy.arsystem.general To: [email protected] Sent: Monday, April 06, 2009 12:48 PM Subject: Finding LArgest free block in a table grid ** Dear friends, I am representing racks of book shelf as a table grid in Remedy. Each grid/record is a single unit.some units are ocuupied and some are free. I need to find out the largest available/free block in that Grid. Any help will be highly appreciated! -- Regards, Bhupesh Gupta __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

