Jump To: Material Shape Length 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 Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)
Material
Alloy {574} | Aluminum {791} | Brass {203} | Bronze {82} | Cast Iron {53} |
Copper {96} | Delrin (Acetal) {29} | Nylon {30} | Stainless Steel {811} | Steel {1565} |
Tool Steel {585} |
Shape
Length
Custom Lengths | Custom Lengths | 3.75" | 7.5" | 8" | 8.5" | 8.75" | 10" | 10.5" | 11" | 11.5" |
12" | 15.5" | 15.75" | 16" | 16.75" | 17" | 17.5" | 18" | 22" | 22.25" | 22.5" |
22.75" | 23" | 23.5" | 24" | 35" | 36" | 48" | 60" | 72" |
Grade
Condition
{59} | Annealed {238} | Heat Treated {214} | Other {4307} |
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 {2627} | Turned Grnd & Polished {65} |