Search Page

Please input the word(s) that you would like to search for in our product database. For additional control you may choose to search on "All Words" or "Any Words" or for the "Exact Phrase."  For additional search options you may use our Advanced Search page.

Search    In    
| Advanced Search

Error -2147217913: Cannot convert a char value to money. The char value has incorrect syntax.

SQL SELECT sfProducts.prodID, sfProducts.prodImageLargePath FROM (sfProducts LEFT JOIN sfSubCatDetail ON sfProducts.prodID = sfSubCatDetail.ProdID) LEFT JOIN sfSub_Categories ON sfSubCatDetail.subcatCategoryId = sfSub_Categories.subcatID Where (sfProducts.IncludeInSearch Is Null Or sfProducts.IncludeInSearch=0) And (sfProducts.prodEnabledIsActive=1) And (prodStatus='For Sale') and convert(money,prodPrice)>=500