How do we define not equal login when using a CASE WHEN statement ie. (see the "NOT EQUAL" line below)
SET CalculatedPrice =
when "NOT EQUAL" 100 then FLOOR(inserted.Price) + ( ( (inserted.Price - FLOOR(inserted.Price)) / inserted.Denomination ) * 100 )
Have tried all the usual <>, != NOT etc etc not doubt SQL has it's own idiosyncratic way of doing it!