Current Criteria (Reset)
2401 products found, 2401 variants found. Show All Items
![]() | 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 Finish='Other ' and Length=36 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other
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