Hi I have been trying to work out the best way to do this today to
What I would ideally like to do is to create an
alias distance calculated by the SQL formula below (although I am open
to other ways of calculating the distance, this was just the way that
seemed it should be easiest)
Once I have that alias I want
to be able to use it in a Restrictions fashion to find all that are
within a certain distance.
I would also like to be able to
sort via distance.
This is part of a bigger search
criteria that is built up so I would ideally like to keep using
Criteria. ( I already limit the range of Lat and L