The following two examples show how to use the SpheroidalDistance function to get the spheroidal distance between Madison (-89.39, 43.09) and Chicago (-87.65, 41.90):
SELECT SYSSPATIAL.SpheroidalDistance( -89.39, 43.09, -87.65, 41.90, 6378137, 298.257223563); SELECT SYSSPATIAL.SpheroidalDistance( -89.39, 43.09, -87.65, 41.90);