Current Criteria (Reset)
20 products found, 20 variants found. Jump To Items
Shape=Drill Rod | |
Grade=A-2 |
All items with these criteria are: Material=Tool Steel, Length=36, 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='Drill Rod ' and Grade='A-2' 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/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1/16" |
1/8" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1/8" |
3/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 3/16" |
1/4" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1/4" |
5/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 5/16" |
3/8" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 3/8" |
7/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 7/16" |
1/2" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1/2" |
9/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 9/16" |
5/8" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 5/8" |
11/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 11/16" |
3/4" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 3/4" |
13/16" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 13/16" |
7/8" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 7/8" |
1" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1" |
1-1/8" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1-1/8" |
1-1/4" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1-1/4" |
1-1/2" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1-1/2" |
1-3/4" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 1-3/4" |
2" {A} Rd A-2 Drill Rod | Drill Rod | A-2 | 2" |