UFN_CURRENCY_GETCURRENCYFROMISO
Returns the ID of the currency with the given ISO4217 code.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ISO4217 | nvarchar(3) | IN |
Definition
Copy
create function dbo.UFN_CURRENCY_GETCURRENCYFROMISO
(
@ISO4217 nvarchar(3)
)
returns uniqueidentifier
with execute as caller
as
begin
return
(
select
CURRENCY.ID
from
dbo.CURRENCY
where
CURRENCY.ISO4217 = @ISO4217
);
end