Subject RE: [ib-support] Extra Field?
Author Leyne, Sean
Mike,

What programming language do you use?

I would think that you could create a UDF to calculate and return the
distance, which you could then sort by. The UDF call would look like:

SELECT DISTANCEUDF( :TargetPointLat, :TargetPointLong, LATITUDE,
LONGITUDE), COLUMNS, ..., FROM ... WHERE ... ORDER BY 1


Sean

P.S. Mike, what to over-quoting -- thanks.