Current Criteria (Reset)
2401 products found, 2401 variants found. Show All Items
Condition=Other | |
Finish=Other | |
Length=36 |
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 Condition='Other ' and Finish='Other' and Length=36 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Alloy {15} | Aluminum {680} | Brass {190} | Bronze {82} | Copper {81} |
Stainless Steel {742} | Steel {379} | Tool Steel {232} |
Shape
Angle {71} | Channel {15} | Drill Rod {107} | Flat {694} | Ground Flat {125} |
Hexagon {66} | Rectangular Tube {77} | Round {528} | Round Pipe {39} | Round Tube {428} |
Square {103} | Square Tube {95} | Threaded Rod {53} |
Grade