Thanks guys for your help.

I came with the invoice example just for reference, to simplify the scenario, but probably I should give you the real example.

As my first remark -...

Thanks!

This is what I needed.

Well, it is "almost" good 😀

PRINT round(1.23456, 2)

displays 1.230000, while I need 1.23

I know it is not a good behaviour to format from SQL, but I really have to.

That worked, thanks.

Now I am wondering how this can be used in a view 😀

I guess it is not possible. I was thinking about creating an udf to format decimal,...