UFN_CURRENCY_APPLYRATE

Aids in currency conversions by applying an exchange rate to an amount. The value returned has 9 digits to the right of the decimal.

Return

Return Type
decimal(38, 9)

Parameters

Parameter	Parameter Type	Mode	Description
@AMOUNT	money	IN
@RATE	decimal(20, 8)	IN

Definition

Copy



            CREATE function dbo.UFN_CURRENCY_APPLYRATE
            (
                @AMOUNT money,
                @RATE decimal(20,8)
            )
            returns decimal(38,9)
            with schemabinding
            as begin
                return (convert(decimal(20,4),@AMOUNT) * @RATE);
            end