EULANDA® ERP System Head Start thru Technology

cnf_eurokurs (SQL API)

Back | Level back

Returns the official euro exchange ratio of the individual national currencies.

Syntax

cnf_eurokurs @currency

Argument

@currency char(3)

The international three figure currency contraction consisting of the two digit country code and the initial letter of the currency designation. For currencies those will not belong the euro-area returned NULL.

Example

SELECT 
  dbo.cnf_eurokurs('DEM') [One EUR corresponds x Deutsche Mark], 
  dbo.cnf_eurokurs('AST') [One EUR corresponds x Schilling]  

Output:

One EUR corresponds x DM  Ein EUR corresponds x Schilling 
---------------------  ---------------------------- 
1.955830               13.760300

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.