Login
Clearsynth
QUICK ORDER
Menu

sales@clearsynth.com

Helpline Numbers :
+1-858-293-4888 (San Diego)
+1-289-729-0060 (Toronto)
+91-22-45045900 (Mumbai)
+91-40-6910-6800 (Hyderabad)


Contact Us

Catalog Products

SELECT Distinct parentchemical as pparentchemical,IIF(parentchemical LIKE '[a-z]%', 0, 1) AS FilterValue FROM tblproducts WHERE parentchemical <> '' and parentchemical is not null and parentchemical <> 'null' and compound <> '' AND parentchemical NOT LIKE '%[0-9]%' and compound is not null and websiteDisplay = 'Y' and catnumber not like '%ML%' and structure <> '' and structure is not null and structure <> '' and structure is not null and structure <> 'NA' and structure <> 'N/A' and structure <> 'Clearsynth.png' and structure <> 'null' and structure <> 'Not Available' and structure <> 'Not Available' AND parentchemical LIKE 'A%' ORDER BY parentchemical