Current Criteria (Reset)
1450 products found, 1450 variants found. Show All Items
![]() | Material=Steel |
![]() | Length=36 |
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=36 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} | ![]() Hexagon {48} | ![]() Rectangular Tube {62} |
![]() Round {355} | ![]() Round Pipe {15} | ![]() Round Tube {226} | ![]() Square {72} | ![]() Square Tube {59} |
![]() Threaded Rod {17} |
Grade
1018 {479} | 1045 {105} | 1117 {17} | 11L17 {10} |
1215 {13} | 12L14 {106} | A-36 {284} | Other {362} |
Stressproof (1144) {57} | Zinc Plated {17} |
Finish
Cold Finished {660} | Hot Rolled {362} | Other {379} | Turned Grnd & Polished {49} |