Current Criteria (Reset)

2302 products found, 2302 variants found.  Show All Items

	Condition=Other
	Finish=Other
	Length=12

Jump To: Material    Shape    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 Condition='Other' and Finish='Other' and Length=12 And Convert(Int, Thickness) Is Not NULL GROUP BY Convert(Int, Thickness) ORDER BY Convert(Int, Thickness)

Aluminum {788}	Brass {203}	Bronze {82}	Copper {95}	Stainless Steel {772}
Steel {362}

Angle {71}	Channel {15}	Flat {693}	Hexagon {66}	Plate {144}
Rectangular Tube {77}	Round {528}	Round Pipe {39}	Round Tube {428}	Sheet {43}
Square {103}	Square Tube {95}