quote:

---

Originally posted by creichard

I have a query which returns the businesses within a list of zip codes generated by the user. The interface is a simple proceedure where the user enters a zip code and a radius. The code then generates a list of zip codes within that radius. Pretty basic.

Here's my SQL question: I need to sort the query results by zip code with the first zip code being the zip code the user entered, then the remaining results are sorted asc by zip code. How do I define the sort statement to list the users zip code first then all other zip codes?

thanks all

---

quote:

---

Originally posted by tosscrosby
...They is no way to do a dual sort on a single column within a single select statement...

---

order by
	case
	when ZipCode = @UserZipCode
	then 0
	else 1
	end,
	ZipCode

quote:

---

Originally posted by rohitkumar

quote:

---

Originally posted by creichard

I have a query which returns the businesses within a list of zip codes generated by the user. The interface is a simple proceedure where the user enters a zip code and a radius. The code then generates a list of zip codes within that radius. Pretty basic.

Here's my SQL question: I need to sort the query results by zip code with the first zip code being the zip code the user entered, then the remaining results are sorted asc by zip code. How do I define the sort statement to list the users zip code first then all other zip codes?

thanks all

---

and how does this query work? I'm getting curious. Zip code cannot be a single co-ordinate, how do you find zip codes within fixed a distance from one spot?

---

quote:

---

Originally posted by rohitkumar

but then zip code is for an area and its not just 2 co-ordinates

A-------D----------------------------------------------B

so here if you have co-ordinates for two zip codes A (which may be Sears tower standing on a small patch of land and having its own zip code) and B how do you find if business D lies in zip code A or zip code B? you have to know the border too right?

---

quote:

---

Originally posted by Michael Valentine Jones

quote:

---

Originally posted by tosscrosby
...They is no way to do a dual sort on a single column within a single select statement...

---

Never say never:

order by
	case
	when ZipCode = @UserZipCode
	then 0
	else 1
	end,
	ZipCode

CODO ERGO SUM

---

ORDER BY	NULLIF(ZipCode, @UserZipCode)

ORDER BY	NULLIF(ZipCode, @UserZipCode), ZipCode DESC