>SELECT * FROM thetable a >WHERE ROUND(theid,-2) <> theid >OR (ROUND(theid,-2) = theid AND (SELECT count(*) FROM thetable b WHERE >b.theid > a.theid AND b.theid <= a.theid + 99) = 0)
Thanks Jim! Initial testing shows it works great! Interesting use of round(). Takes about 1.0 second to return 904 records from 955 total. Any ideas on how I could make it quicker? Doug ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2764 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
