getting certain location points from a database

I'm creating an Android application that needs to find all the points within a given radius of the device. However these locations will be stored in a database either SQL (on a server) or SQLite (for early testing/demo), what I dont want to do is get all the locations and filter down on the device as the could potentially be thousands of points. The locations are stored as two separate fields for latitude and longitude, how could I get only the points from the database that are within a certain radius of a location?