CONVERT() should accept a price as parameter

[blais]

Original report by Martin Michlmayr (Bitbucket: tbm13, GitHub: tbm).

---

Sometimes I want to convert one currency to another at a fixed rate that does not necessarily reflect any actual exchange rate. For example, when doing a net worth converted to one currency, I may have some "long time, real" exchange rate in mind even though it's not the current exchange rate.

So for example I want to say convert all GBP to EUR and assume "1 GBP equals 1.45 EUR". It would be nice if CONVERT() would accept something like this, e.g.

CONVERT(position, "GBP 1.45 EUR") or CONVERT(position, "GBP @ 1.45 EUR")