Current Criteria (Reset)
1381 products found, 1381 variants found. Show All Items
![]() | Shape=Round |
![]() | Length=36 |
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=36 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} |