Current Criteria (Reset)
1512 products found, 1512 variants found. Show All Items
Material=Steel | |
Condition=Other | |
Length=12 |
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=12 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 {61} |
Rectangular Tube {62} | Round {355} | Round Pipe {15} | Round Tube {226} | Sheet {18} |
Square {72} | Square Tube {59} |
Grade
1018 {479} | 1045 {116} | 1117 {17} | 11L17 {10} |
1215 {13} | 12L14 {106} | A-36 {320} | Diamond Plate {3} |
Grade 50 {11} | Other {380} | Stressproof (1144) {57} |
Finish
Cold Finished {660} | Cold Rolled {10} | Galvanized {8} | Hot Rolled {423} |
Other {362} | Turned Grnd & Polished {49} |