Current Criteria (Reset)
2427 products found, 2427 variants found. Show All Items
Condition=Other | |
Finish=Other | |
Length=18 |
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=18 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Aluminum {788} | Brass {203} | Bronze {82} | Copper {95} | Stainless Steel {772} |
Steel {362} | Tool Steel {125} |
Shape
Angle {71} | Channel {15} | Flat {693} | Ground Flat {125} | Hexagon {66} |
Plate {144} | Rectangular Tube {77} | Round {528} | Round Pipe {39} | Round Tube {428} |
Sheet {43} | Square {103} | Square Tube {95} |
Grade