Cation exchange resin is also known as cation deionization resin or water softener resin depending on how it is chemically charged. Cation (Cat-Ion resin in the sodium (Na- form is used to soften water by trading calcium (ca and magnesium (mg for sodium (na . Cation resin in the hydrogen (H form the resin is used to trade all positively charged ions in water for hydrogen. (when used with Anion Resin (OH it makes pure water. H_OH = Pure H20. Related Articles How Much Media do you need? How To Change Resin In a Water Softener All About Water Softeners

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 = 617 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