Current Criteria (Reset)
1382 products found, 1382 variants found. Show All Items
![]() | Shape=Round |
![]() | Length=1 |
Jump To: Material Grade Condition Finish
All items with these criteria are: Thickness=Select Convert(Int, Thickness) TheField, Count(DISTINCT Product.ProductID) TheCount FROM Product with (NOLOCK) INNER JOIN ProductVariant with (NOLOCK) On Product.ProductID = ProductVariant.ProductID WHERE Shape='Round' and Length=1 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
![]() Alloy {261} | ![]() Aluminum {139} | ![]() Brass {42} | ![]() Bronze {37} | ![]() Cast Iron {22} |
![]() Copper {17} | ![]() Delrin (Acetal) {29} | ![]() Nylon {30} | ![]() Stainless Steel {293} | ![]() Steel {355} |
![]() Tool Steel {157} |
Grade
Condition
{59} | Annealed {96} | Heat Treated {89} | Other {1138} |
Finish
{59} | Cold Finished {320} | De-Carb Free {157} | Hot Finished {22} |
Hot Rolled {231} | Other {528} | Turned Grnd & Polished {65} |