Current Criteria (Reset)

2336 products found, 2336 variants found.  Show All Items

	Condition=Other
	Finish=Other
	Length=24

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=24 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 {396}

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