Philip If your Shield nodes are identified numbered sequentially, e.g. ShieldNo, beginning at 1, then you could probably do:
Select * from ShieldLayer where ShieldLayer.ShieldNo MOD 5 = 0 That should get every 5th shield, so every 5 miles. HTH Terry McDonnell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 15:16 To: Terry McDonnell Subject: MI-L SQL help? Group I have a Interstate shield's layer for the U.S. that has a shield (node) every mile along that Interstate. What I want to do is make the same layer but, only have nodes that are 5 miles apart. Any ideas on how to do this? Thanks for any help. -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] -------------------------------------------------------------------- ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15688 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15696