Hi Lowell, thanks for your reply.

The cost price is service related and not an end product as such, we add mark up to the price as a middleman scenario, so...

Hi and thanks for your suggestion, i shall give that a whirl now.

I have also tried the following:

DECLARE @Cost FLOAT

SELECT @Cost =SUM(Cost)*10/100 FROM dbo._Cost_Test

SELECT Mark_Up,@Cost,Mark_Up+@Cost FROM dbo._Cost_Test

Which outputs...