Current Criteria (Reset)
2624 products found, 17937 variants found. Show All Items
Finish=Other |
Jump To: Material Shape Length Grade
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 Finish='Other ' And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other
Material
Alloy {15} | Aluminum {789} | Brass {203} | Bronze {82} | Copper {95} |
Stainless Steel {794} | Steel {414} | Tool Steel {232} |
Shape
Length
Custom Lengths | 12" | 18" | 24" | 36" | 48" | 60" | 72" |
Grade