Current Criteria (Reset)
1 products found, 3 variants found. Jump To Items
Material=Steel | |
Shape=Plate | |
Finish=Other |
All items with these criteria are: Length=1, 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 Material='Steel' and Shape='Plate ' and Finish='Other' And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Grade=Other, Condition=Other
Items
Product | Shape | Grade | Thickness | Width | Wall |
---|---|---|---|---|---|
13ga (0.182" {A}) x 0.313" {B} x 0.938" {C} Flattened Expanded Metal | Plate | Other | 0.182" | 0.313" | 1.000" |