SELECT p.* FROM dev1.ds_products as p, ds_product_categories as c, ds_product_option_sets as d where (p.invLevel > 0 or (p.invTrack = 'O' and d.inventory > 0)) and p.pID = d.productId and p.pID = c.pID and c.catID !=0 and p.pAvail = 'Y' and ( p.venID = '25' ) and p.pID Not in (135,137,138) and p.pID in (0,0,135,136,137,138,139,140,544,712) group by p.pID order by case c.sortOrder when 0 then 100 else c.sortOrder end
We bring modern technology and styling to physician uniforms.
For those medical professionals who strive for a sharp appearance and strong first impression.
Stains Roll Off
Advanced Dual Action TeflonÂ® fabric protector is a perfect match with our lab coats - a repel and release technology that aggressively fights the most common lab coat and scrubs stains.
TeflonÂ® is a registered trademark of DuPont used under license by Medelita.
Watch live testimonials from your colleagues at medical conferences.