Newsletter Subscriptions

You may subscribe to our newsletter mailing list or remove yourself from our mailing list. Per the terms of our privacy policy we do not share this information with anybody.


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