To Donald -
select str$(obj) from mytable ... to get a list of the different types of objects in your table select * from mytable where str$(obj) = "Point" ... select point objects select * from mytable where str$(obj) = "Line" ... Line objects select * from mytable where str$(obj) = "Polyline" select * from mytable where str$(obj) = "Region" regards Bo Thomsen -----Oprindelig meddelelse----- Fra: DON [mailto:[EMAIL PROTECTED]] Sendt: 24. maj 2002 21:45 Til: MapINFO Emne: MI-L Object search Hi List, I have a table that should contain only line objects but it also contains some extreneous objects (i.e., when you open Layers >> Display there are point and polygon objects indicated). How can I search for objects by their type? Can I construct an SQL search for all point objects, etc...? Donald Guerra ~~~~~~~~~~ Municipal Authority of Westmoreland County Distribution Supervisor - GIS 724-834-6500 x182 [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]