Current Criteria (Reset)
17 products found, 17 variants found. Jump To Items
| Grade=1117 | |
| Finish=Cold Finished | |
| Length=1 |
All items with these criteria are: Material=Steel, Shape=Round, 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 Grade='1117' and Finish='Cold Finished ' and Length=1 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness), Condition=Other
Items
| Product | Shape | Grade | Thickness | Width | Wall |
|---|---|---|---|---|---|
| 3/8" {A} Rd Cold Finished 1117 | Round | 1117 | 3/8" |
| 1/2" {A} Rd Cold Finished 1117 | Round | 1117 | 1/2" |
| 5/8" {A} Rd Cold Finished 1117 | Round | 1117 | 5/8" |
| 3/4" {A} Rd Cold Finished 1117 | Round | 1117 | 3/4" |
| 1" {A} Rd Cold Finished 1117 | Round | 1117 | 1" |
| 1-1/4" {A} Rd Cold Finished 1117 | Round | 1117 | 1-1/4" |
| 1-3/8" {A} Rd Cold Finished 1117 | Round | 1117 | 1-3/8" |
| 1-1/2" {A} Rd Cold Finished 1117 | Round | 1117 | 1-1/2" |
| 1-5/8" {A} Rd Cold Finished 1117 | Round | 1117 | 1-5/8" |
| 1-3/4" {A} Rd Cold Finished 1117 | Round | 1117 | 1-3/4" |
| 2" {A} Rd Cold Finished 1117 | Round | 1117 | 2" |
| 2-1/2" {A} Rd Cold Finished 1117 | Round | 1117 | 2-1/2" |
| 2-3/4" {A} Rd Cold Finished 1117 | Round | 1117 | 2-3/4" |
| 3" {A} Rd Cold Finished 1117 | Round | 1117 | 3" |
| 3-1/2" {A} Rd Cold Finished 1117 | Round | 1117 | 3-1/2" |
| 4" {A} Rd Cold Finished 1117 | Round | 1117 | 4" |
| 6" {A} Rd Cold Finished 1117 | Round | 1117 | 6" |