UFN_COUNTRY_GETISO3166CODE

Returns the ISO3166 code for a given country.

Return

Return Type
nvarchar(2)

Parameters

Parameter	Parameter Type	Mode	Description
@COUNTRYID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_COUNTRY_GETISO3166CODE
        (
            @COUNTRYID uniqueidentifier = null
        )
        returns nvarchar(2)
        with execute as caller
        as begin
            return (
                select ISO3166 from dbo.COUNTRY
                where ID = @COUNTRYID
            )
        end