MI selecting objects

I am trying to select items from a table which contains all the roads in a county. There are names within a column such as CSAH 1, CSAH 2 and so on, along with others like State Hyw 1, Interstate 90, etc. I want to select all names which contain CSAH. How can I do this? I porbalbly haven't

MI remove street names from address

I have a table with a column of street addresses such as 14963 140th St. I want to remove the 140th St portion and be left with just 14963 in either that column or another column. Can this be done in Mapinfo or Excel? If so how? Thank you Dave Lagerstedt

MI selecting points on a boundary

I have a bounday of a farm field which was drawn using GPS. I believe the points that make up the boundary were recorded with their altitude data. I would first like to know if the altitude data is stored. If it is, then I need to use that data. Can you help? Dave Lagerstedte-mail [EMAIL