Anion exchange resin is also known as anion deionization resin or dealkalizer resin depending on how it is chemically charged. Anion resin in the chloride (Cl- form is used to dealkalize water by trading carbonate for chloride. Anion resin in the hydroxyl (OH form the resin is used to trade all negatively charged ions in water for hydroxyl. (when used with cation H_OH = Pure H20. How Much Media do you need?

select DISTINCTROW top 10 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 8 and p.hide = 0 and (p.customermatch is null or p.customermatch = '') and (p.loggedin = false or p.loggedin is null) and (c.customermatch is null or c.customermatch = '') and (c.loggedin = false or c.loggedin is null) AND (higherCatalogId is null) order by p.ccode