Hi all, Anyone know how to do a SQL statement that looks for the majority of an object within another? I have a table of road segments, and a table of highway extents (adopted highway). I need to check whether the road segments just intersect (and therefore are not adopted highway) and those where the bulk of the road segment object is within the adopted highway table.
I can't use contain entire or contain part since even the slightest touch counts...I'm looking for a function that deems the majority of an object is within another (say 50% plus)? Ben __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7493
