The Mod keyword might be what you need.
i.e.
SELECT * FROM ContourTable WHERE ElevationColumn MOD 5 = 0
This will return all values of Elevation that can be divided exactly by 5.
Hope that helps,
Dominic
-Original Message-
From: Véronique De Laet [mailto:[EMAIL PROTECTED]
Sent: 17
Sorry, missed Bill's answer!
-Original Message-
From: Bill Thoen [mailto:[EMAIL PROTECTED]
Sent: 17 July 2004 22:18
To: Véronique De Laet
Cc: [EMAIL PROTECTED]
Subject: Re: MI-L sql select problem
On Sat, 17 Jul 2004, Véronique De Laet wrote:
We have a database with elevation values
On Sat, 17 Jul 2004, Véronique De Laet wrote:
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.
If you want to select contour lines with elevation values that are even
multiples of 5m, you can do so