Converts legacy European national currencies to and from Euros.
CONVERT(value; currency1; currency2)
- value is the amount of the currency to be converted.
- currency1 and currency2 are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"), as shown in the table below. The rates (shown per Euro) were set by the European Commission. The legacy currencies were replaced by the Euro in 2002.