Current Criteria (Reset)
1412 products found, 1412 variants found. Show All Items
Shape=Flat | |
Condition=Other | |
Length=1 |
Jump To: Material 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 Shape='Flat ' and Condition='Other' and Length=1 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Aluminum {266} | Brass {86} | Bronze {41} | Cast Iron {20} | Copper {57} |
Stainless Steel {243} | Steel {511} | Tool Steel {188} |
Grade
1018 {339} | 110 {57} | 2024 {60} | 303 {74} |
304 {109} | 316 {60} | 360 {86} | 6061 {171} |
7075 {35} | 954 {41} | A-2 {134} | A-36 {172} |
Class 40 {20} | D-2 {54} |
Finish
Cold Finished {339} | De-Carb Free {188} | Hot Finished {20} | Hot Rolled {172} |
Other {693} |