Chris Morris (3/27/2009)

---

You're welcome Blanktree, thanks for the feedback.

If you don't already know, TSQL has two flavors of CASE, simple and searched. The query above uses the searched flavor because...

Chris Morris (3/27/2009)

---

Is this what you're looking for?

-- make up some sample data

DROP TABLE #tbl_Listings

CREATE TABLE #tbl_Listings (Location VARCHAR(20), Price MONEY)

INSERT INTO #tbl_Listings (Location, Price)

SELECT 'RM10', 100000 UNION ALL

SELECT 'RM20',...