USP_GET_COUNTRYADDRESSFORMAT

        CREATE PROCEDURE dbo.USP_GET_COUNTRYADDRESSFORMAT
            @COUNTRYNAME NVARCHAR(200) = NULL
        AS 
        BEGIN
            DECLARE @CountryID UNIQUEIDENTIFIER 

            IF @CountryName IS NOT NULL BEGIN    -- If country name is provided

                SELECT @CountryID = C.ID FROM dbo.COUNTRY AS C WHERE C.DESCRIPTION = @COUNTRYNAME
          END
            ELSE BEGIN -- Default Country

                SELECT @CountryID = C.ID FROM dbo.COUNTRY AS C WHERE C.DESCRIPTION = 'United States'
            END

            SELECT CF.FORMATSTRING AS AddressFormat FROM dbo.COUNTRYADDRESSFORMAT AS CF
            INNER JOIN dbo.COUNTRY AS C ON C.COUNTRYADDRESSFORMATID = CF.ID
            WHERE C.ID = @CountryID   

        END