Query out the records with the zero lat zero Long, make them editable in a map window and under the edit menu choose "Clear Map Objects Only", this will delete the spatial component of the record while leaving the attribute data intact.
Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: Alan Gunn [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:59 PM To: [EMAIL PROTECTED] Subject: MI-L destroy points List, I would like to delete points in a table without actually deleting records. The points were created based on lat long values. Some lat long values were blank, and they were arbitrarily placed in the ocean. I could just move the points from their arbitrary location to where I need them and then update the lat long columns again, but it seems like there is an easier way that I am not seeing. It seems simple, but I just can't find it. I could probably start over with the table from its creation, and then create only the selected points, but I wonder if there is a tool or function. Thanks, Alan Alan Gunn Residential Strategies, Inc. [EMAIL PROTECTED] 16660 Dallas Parkway #1200 Dallas, Texas 75248 972.381.1400 office 972.381.1410 fax The information contained in this e-mail is strictly confidential and for the intended use of the addressee only. Any disclosure, use or copying of the information by anyone other than the intended recipient is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail. Residential Strategies, Inc. has taken every reasonable precaution to insure that any attachment to this e-mail has been checked for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.
