Current Criteria (Reset)
1433 products found, 1433 variants found. Show All Items
Material=Steel | |
Condition=Other | |
Length=48 |
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=48 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} | 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 {362} |
Stressproof (1144) {57} |
Finish
Cold Finished {660} | Hot Rolled {362} | Other {362} | Turned Grnd & Polished {49} |