I have a table that holds formulas, for example [AMT]*[FX_RT]*[VAT_RT]. I need to select from this table and add a new column containing the results. All of the bracketed values in this "formula" column are references to actual columns on the table. So there is an AMT, FX_RT and VAT_RT column on this table.
SELECT '10000*.875*.0524879' FORMULA, CONVERT(MONEY,10000*.875*.0524879,0) AS I_NEED_THIS_COLUMN