title: Getting all zip codes with a distance of 50 miles from a specific zip code
body: <p>I have a page where a user can insert their zip code and it will return all zip codes near their code.</p>
  
  <p>Right now I have this table</p>
  
  <pre><code>CREATE TABLE [dbo].[zip](
      [zipcode] [varchar](5) NOT NULL,
      [state] [varchar](2) NULL,
      [city] [varchar](50) NULL,
      [longitude] [float] NULL,
      [latitude] [float] NULL,        
      [CreateStamp] [smalldatetime] NULL,
      [state_name] [varchar](50) NULL,        
  )
  </code></pre>
  
  <p>I'm not sure how to do this if you can give me a full instruction it would be great </p>
  
  <p>Outcome would be a user insert their zip code, then the query would return all zip codes within 50 miles of their own zip code.</p>