What I am tryeing to do is,

SELECT * FROM EXPERIAN WHERE LATITUDE BETWEEN 'XXXXXXXXX' AND 'XXXXXXXXX'
AND
LONGITUDE BETWEEN 'XXXXXXXXX' AND 'XXXXXXXXX'

Works very well with Firebird.

I know the center point of the lat and long and i have a math formula that
computes the distance.

what i need to do is sort the result set by the the distance from the
target lat and long.

Any recemondations?

thanks, mike

-----Original Message-----
From: Leyne, Sean [mailto:InterbaseSupport@...]
Sent: Friday, August 24, 2001 9:23 AM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] Extra Field?


Mike,

With Firebird v1 you can GROUP BY a UDF, not SORT BY though. There is a
work around to the SOR BY problem, you can:

SELECT COLUMNA, SOMEFUNCTION() B FROM TABLE ORDER BY 2


Sean

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Do you need to encrypt all your online transactions? Secure corporate intranets? Authenticate your Web sites? Whatever
security your site needs, you'll find the perfect solution here!
http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/dpFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/