Filter latitude and longitude records based on for given latitude and longitude for given n kilometre [duplicate]

This question already has an answer here:

• SQlite Getting nearest locations (with latitude and longitude) 7 answers

I have latitude and longitude stored in a table and I want to filter the records that are in n kilo meter radius from the given latitude and longitude.

I searched sql-server management studio system functions But it is not having any.

any valuable suggestions on how do I go about solving this issue would be helpful..

Note:

I am looking for a solution that uses just plain-sql coupled with forumlas so that it can be used in other db such as sqlite too.