Current Criteria (Reset)
4551 products found, 4551 variants found. Show All Items
Length=12 |
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=12 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Alloy {559} | Aluminum {788} | Brass {203} | Bronze {82} | Cast Iron {53} |
Copper {95} | Delrin (Acetal) {29} | Nylon {30} | Stainless Steel {789} | Steel {1513} |
Tool Steel {353} |
Shape
Angle {127} | Channel {44} | Flat {1612} | Hexagon {128} | Plate {260} |
Rectangular Tube {77} | Round {1382} | Round Pipe {39} | Round Tube {428} | Sheet {79} |
Square {223} | Square Tube {95} |
Grade
Condition
{59} | Annealed {238} | Heat Treated {214} | Other {3982} |
Finish
{59} | #2 Finish {10} | #4 Finish {7} | Cold Finished {844} |
Cold Rolled {10} | De-Carb Free {517} | Galvanized {8} | Heat Treated {24} |
Hot Finished {53} | Hot Rolled {594} | Other {2302} | Turned Grnd & Polished {65} |