Sreenivasa Reddy Thotli

 To get near by cities which are having longitude and latitude within specific distance in database SELECT * FROM ( SELECT * FROM ( SELECT *,(((acos(sin((@latitude*pi()/180)) * sin((Latitude*pi()/180))+cos((@latitude*pi()/180))  * cos((Latitude*pi()/180)) * cos(((@longitude - Longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance  FROM tblCities ) t )x where distance <= 1000 ORDER by distance

List of special Characters in HTML left single quote   &lsquo; ‘ right single quote   &rsquo; ’ single low-9 quote   &sbquo; ‚ left double quote   &ldquo; “ right double quote   &rdquo; ” double low-9 quote   &bdquo; „ dagger   &dagger; † double dagger   &Dagger; ‡ per mill sign   &permil; ‰ single left-pointing angle quote   &lsaquo; ‹ single right-pointing angle quote   &rsaquo; › black spade suit   &spades; ♠ black club suit   &clubs; ♣ black heart suit   &hearts; ♥ black diamond suit   &diams; ♦ overline, = spacing overscore   &oline; ‾ leftward arrow   &larr; ← upward arrow   &uarr; ↑ rightward arrow   &rarr; → downward arrow   &darr; ↓ trademark sign &#x2122; &trade; ™ unused &#00;- &#08;     horizontal tab &#09;     line feed &#10; ...