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 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 like this:

Select * from MyContours where MyElevation mod 5 = 0

- Bill Thoen



---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12659




---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12666

Reply via email to