If you cannot use the MOD function, use the statement WHERE: INT(ELEVATION/5) = (ELEVATION/5) This works well
Have luck SERGI -----Mensaje original----- De: Véronique De Laet [mailto:[EMAIL PROTECTED] Enviado el: sábado, 17 de julio de 2004 21:30 Para: [EMAIL PROTECTED] Asunto: MI-L sql select problem Dear list, We have a database with elevation values of contourlines with an aquidistance of 1m. Now we want to select lines with an interval of 5m. So we tried the sql select function: table: the contour table column: the elevation values where condition: And here we stuck. Can someone give us some advise about how we can solve this sql select? greetings, veronique --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12667