UFN_QTRANSLATE_COUNTRY_GETABBREVIATION

This function returns the abbreviation for a given country.

Return

Return Type
nvarchar(10)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_QTRANSLATE_COUNTRY_GETABBREVIATION(@ID uniqueidentifier) returns nvarchar(10)
            AS
            --Used by QueryViews and SmartQueries

            BEGIN
                declare @ABBREVIATION nvarchar(10)

                select @ABBREVIATION = ABBREVIATION from dbo.COUNTRY where ID = @ID

                RETURN @ABBREVIATION
            END