SQL View Calculation

[rafeman]

Hi,

Is it possible to have a calculation within a view?

E.g. SQLView

Date Amount
13/03/07 £100
13/03/07 £1000

I would like a manually calculated field in the view for VAT. E.g.

Date Amount VAT
13/03/07 £100 £17.50
13/03/07 £1000 £117.50

Is there a way of doing this and how?

Thanks

 

[SQLDenis]

something like this

create view blah
as select Date Amount, (amount * .1750) as vat
from table

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[rafeman]

Thanks thats great.