I'm new to this so I wasn't really sure where to ask this. I am in the process of importing about 420,000 products into version 3.80. The files contain my cost (ProductCost) and MSRP (Price). The problem is that several did not have an MSRP (Price) value or it is not enough margin to be published. I want to leave the MSRP values in the (Price) column so that I can move them to the (OldPrice) column and I think I can change the string value of products.price.oldprice to "MSRP" to display MSRP price to the customers and adjust the (Price) with a percentage increase over (ProductCost). Now I'll get to my question. I can't seem to get this query correct. I want to set (Published) to false if (Price) is < (ProductCost) + 10%.
I tried this but it didn't work.
UPDATE dbo.Product
set Published=False
WHERE Price < (.10>ProductCost)