Customer Accounts

Please log in.

Email Address: 
Password: 
   
 
  Forgot your Password?
Create Account

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