Current Criteria (Reset)
1434 products found, 1436 variants found. Show All Items
Material=Steel | |
Condition=Other | |
Length=1 |
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 Material='Steel' and Condition='Other' and Length=1 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Shape
Angle {56} | Channel {29} | Flat {511} | Hexagon {48} | Plate {1} |
Rectangular Tube {62} | Round {355} | Round Pipe {15} | Round Tube {226} | Square {72} |
Square Tube {59} |
Grade
1018 {479} | 1045 {105} | 1117 {17} | 11L17 {10} |
1215 {13} | 12L14 {106} | A-36 {284} | Other {363} |
Stressproof (1144) {57} |
Finish
Cold Finished {660} | Hot Rolled {362} | Other {363} | Turned Grnd & Polished {49} |