irajoel2000 wrote:

> I use the following sql statement with dbase tables to return records
> that are a certain distance from a zipcode. Each record has a latitude
> and a longitude and a cosine. I then cycle through the rowset and
> filter out those records that are <= the request milage, ie: 10 miles
> from 10011.
>
> I am trying to upgrade to firebird, but the sql statement seems not to
> work with firebird.

It would be much easier to help you if you tell us what is the error
message?


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com