For the specific case you show, you could do something like (Distance (-79.386803, 43.670368, CentroidX(urban.obj),CentroidY(urban.obj),"mi") < 2) and (CentroidX (obj) < -79.386803)
but in the general case, there isn't a straightforward way to do this. Most importantly, you can't "express" direction in the way you want to (that is, there isn't a function built into MapInfo that gives the direction from one point to another). The best you can do is create a region object that approximates your idea of being less than a certain distance from a point in a certain direction, and perform a geographic query on the object (e.g. if the object were stored in a variable named "myfunkybuffer", you'd use the geographic predicate "urban.obj intersects myfunkybuffer" in your WHERE clause). Spencer --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10287
