I have an SQL query built in SQL server. I want to select all products below margin 35%, however It is returning Margins that are 100%? Any ideas on why its doing this?
SELECT
ProductSuppliers.ProductUniqueID AS [ProductSuppliers ProductUniqueID]
,Products.ProductUniqueID AS [Products ProductUniqueID]
,Products.ProductID
,Products.GenericName
,Products.BrandName
,ProductSuppliers.Cost
,ProductSuppliers.CurrentSP
,ProductSuppliers.Margin
FROM
ProductSuppliers
INNER JOIN Products ON ProductSuppliers.ProductUniqueID = Products.ProductUniqueID
WHERE ProductSuppliers.Margin < '35.00'