Current Criteria (Reset)
1381 products found, 1381 variants found. Show All Items
Shape=Round | |
Length=24 |
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=24 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) {28} | Nylon {30} | Stainless Steel {293} | Steel {355} |
Tool Steel {157} |
Grade
Condition
{58} | Annealed {96} | Heat Treated {89} | Other {1138} |
Finish
{58} | Cold Finished {320} | De-Carb Free {157} | Hot Finished {22} |
Hot Rolled {231} | Other {528} | Turned Grnd & Polished {65} |