SELECT * FROM products WHERE Trim(category) = '#Trim(form.category)#' ORDER BY category,productID SELECT * FROM products WHERE ID <> 0 AND Trim(category) LIKE '#url.alphaletter#%' AND (productID LIKE '%#first#%' OR category LIKE '%#first#%' OR description LIKE '%#first#%' OR size LIKE '%#first#%' OR price LIKE '%#first#%') AND (productID LIKE '%#second#%' OR category LIKE '%#second#%' OR description LIKE '%#second#%' OR size LIKE '%#second#%' OR price LIKE '%#second#%') AND (productID LIKE '%#third#%' OR category LIKE '%#third#%' OR description LIKE '%#third#%' OR size LIKE '%#third#%' OR price LIKE '%#third#%') ORDER BY category,productID Your search produced #getSearchResults.recordCount# listings
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

ID Category Description Size Price

#productID# #category# #description# #size# #DollarFormat(price)#_#unit#VARIES

Search Again   |    View Alphabetical Listing