fixed it
replacing distance
with d
edit: also did the sorting as i want!
thanks alot @mark-piller
Hi Mark , how would i use a variable inside this as the POINT data? I.e distanceOnSphere(Area_Point,‘POINT(searchVariable)’)<= 9000
thanks
Jacques