[postgis-users] help with distance query

[mark balman]

Many thanks for your help David, it works!

select astext(the_geom),  distance_spheroid(GeomFromText('Point(-70
20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') from
azev2_1  group  by 1,2 having
distance_spheroid(GeomFromText('Point(-70

20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') <
250000;

What I need also is a field name from azev2_1 called sitename.. I am a
little bit confused as to where I need to put this in this query now?

Thanks again!

Mark