i have the biggest pain in the butt with my data because it is missing a unit cost. i have to calculate the unit cost on the fly and there may or may not be a sale price for any unit. i can get it alright. but when i want to select the next batch of data, i need the records to be bigger than the previous batch's maximum unit cost.

my code looks like this portion:

CASE pv.SalePrice
  WHEN 0 THEN pv.Price / ABS(pv.SKUSuffix)
ELSE 
   pv.SalePrice / ABS(pv.SKUSuffix)
END AS UnitCost   <-------my calculated unit cost

               FROM {databaseOwner}{objectQualifier}aspdnsf_Product p
                    join {databaseOwner}{objectQualifier}aspdnsf_ProductManufacturer pm on p.ProductID = pm.ProductID 
                    join {databaseOwner}{objectQualifier}aspdnsf_Manufacturer m on pm.ManufacturerID = m.ManufacturerID 
                    join {databaseOwner}{objectQualifier}aspdnsf_ProductCategory pc on p.ProductID = pc.ProductID 
                    join {databaseOwner}{objectQualifier}aspdnsf_Category c on pc.CategoryID = c.CategoryID 
                    join {databaseOwner}{objectQualifier}aspdnsf_productvariant pv on p.ProductID = pv.ProductID 
                    join {databaseOwner}{objectQualifier}aspdnsf_SalesPrompt sp on p.SalesPromptID = sp.SalesPromptID
                    left join {databaseOwner}{objectQualifier}aspdnsf_ExtendedPrice e on pv.VariantID=e.VariantID and e.CustomerLevelID=@CustomerLevelID
                WHERE p.ProductID <> @ProductID  

                    and UnitCost > @PreviousMaximumUnitCost <-----this is what I'd LIKE to do but it errors out
                    and pv.SalePrice > 0
                    and p.Deleted = 0
                    and pv.Deleted = 0
                    and p.Published = 1
                    and pv.Published = 1
                    and p.PortalID = @PortalID
                    and pv.VariantID in(select min(VariantID) from {databaseOwner}{objectQualifier}aspdnsf_productvariant where ProductID = p.ProductID and published=1 and deleted=0 and p.published=1 and p.deleted=0)
                ORDER BY UnitCost asc
 

anyone know how i can do this?