Current Criteria (Reset)
4168 products found, 4168 variants found. Show All Items
Length=48 |
Jump To: Material Shape Grade Condition 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 Length=48 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Alloy {504} | Aluminum {680} | Brass {190} | Bronze {82} | Cast Iron {53} |
Copper {80} | Delrin (Acetal) {29} | Nylon {30} | Stainless Steel {721} | Steel {1433} |
Tool Steel {353} |
Shape
Angle {127} | Channel {44} | Flat {1612} | Hexagon {128} | Rectangular Tube {77} |
Round {1382} | Round Pipe {39} | Round Tube {428} | Square {223} | Square Tube {95} |
Grade
Condition
{59} | Annealed {238} | Heat Treated {190} | Other {3668} |
Finish
{59} | Cold Finished {844} | De-Carb Free {517} | Hot Finished {53} |
Hot Rolled {502} | Other {2115} | Turned Grnd & Polished {65} |