Challenging SQL & ASP Question

Results 1 to 2 of 2

Thread: Challenging SQL & ASP Question

  1. #1
    Join Date
    Dec 1969

    Default Challenging SQL & ASP Question

    Hi,<BR>This is a zip code search thing.<BR>A user imputs a zipcode into the asp page form text field and hits submit. I want to return the state associated with it. I have an Access DB that has Zip_Min and Zip_Max columns and a state column that correlates to the zip range. The variable value that is passed will fall somwwhere between the min and max columns. What is the SQL to do this??<BR><BR>Steve

  2. #2
    Join Date
    Dec 1969

    Default Huh??? ''Challenging''?

    SELECT state_name FROM states_and_zips<BR>WHERE 93102 BETWEEN zip_min AND zip_max<BR><BR>Naturally, you shove the selected zip code in there in place of my 93102.<BR><BR>Presto.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts