Current Criteria (Reset)
1547 products found, 1547 variants found. Show All Items
Material=Steel | |
Length=24 |
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 Length=24 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other
Shape
Angle {56} | Channel {29} | Flat {511} | Ground Flat {34} | Hexagon {48} |
Plate {61} | Rectangular Tube {62} | Round {355} | Round Pipe {15} | Round Tube {226} |
Sheet {19} | Square {72} | Square Tube {59} |
Grade
1018 {513} | 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 {396} | Turned Grnd & Polished {49} |