UFN_CURRENCY_GETSYMBOL

Return

Return Type
nvarchar(5)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_CURRENCY_GETSYMBOL
(
    @ID uniqueidentifier
) 
returns nvarchar(5)
with execute as caller
as
begin
    declare @SYMBOL nvarchar(5);

    select
        @SYMBOL = CURRENCYSYMBOL
    from 
        dbo.CURRENCY
    where 
        ID = @ID;

    return @SYMBOL;
end