Current Criteria (Reset)
5 products found, 5 variants found. Jump To Items
| Shape=Rectangular Tube | |
| Grade=304 | |
| Length=24 |
All items with these criteria are: Material=Stainless Steel, 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='Rectangular Tube' and Grade='304' and Length=24 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other, Finish=Other
Items
| Product | Shape | Grade | Thickness | Width | Wall |
|---|---|---|---|---|---|
| 1" {A} x 2" {B} x .120" {C} Wall Rect. Tube 304 Stainless Steel | Rectangular Tube | 304 | 1" | 2" | .120" |
| 2" {A} x 3" {B} x .120" {C} Wall Rect. Tube 304 Stainless Steel | Rectangular Tube | 304 | 2" | 3" | .120" |
| 2" {A} x 4" {B} x .120" {C} Wall Rect. Tube 304 Stainless Steel | Rectangular Tube | 304 | 2" | 4" | .120" |
| 2" {A} x 3" {B} x .188" {C} Wall Rect. Tube 304 Stainless Steel | Rectangular Tube | 304 | 2" | 3" | .188" |
| 2" {A} x 4" {B} x .250" {C} Wall Rect. Tube 304 Stainless Steel | Rectangular Tube | 304 | 2" | 4" | .250" |