Current Criteria (Reset)
4016 products found, 4016 variants found. Show All Items
Condition=Other | |
Length=24 |
Jump To: Material Shape Grade Finish
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 Condition='Other' and Length=24 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Alloy {107} | Aluminum {788} | Brass {203} | Bronze {82} | Cast Iron {53} |
Copper {95} | Stainless Steel {789} | Steel {1546} | Tool Steel {353} |
Shape
Angle {127} | Channel {44} | Flat {1412} | Ground Flat {34} | Hexagon {114} |
Plate {236} | Rectangular Tube {77} | Round {1138} | Round Pipe {39} | Round Tube {428} |
Sheet {78} | Square {194} | Square Tube {95} |
Grade
Finish
#2 Finish {10} | #4 Finish {7} | Cold Finished {689} | Cold Rolled {10} |
De-Carb Free {353} | Galvanized {8} | Hot Finished {53} | Hot Rolled {501} |
Other {2336} | Turned Grnd & Polished {49} |