Submit Feedback

We value your feedback! Please include any suggestions on what we may do to improve our site or tell us what you like to make sure we keep it around.

Help us improve by reporting any errors on this page:

Comments: Please provide an example.

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