Hi

Can I do something like this ?

SELECT Codi_Article, Preu, ROUND(Preu * 1.21, 2) AS PREU_IGI, PREU_IGI - 0.5 AS PREU_DTE
FROM Tarifes

Regards
Robert

Robert,

No.
What you can do instead is:

SELECT
  Codi_Article, Preu, ROUND(Preu * 1.21, 2) AS PREU_IGI, ROUND(Preu * 1.21, 2) - 0.5 AS PREU_DTE
FROM
  Tarifes


--
Fernando Dias
[Team Elevate]