UFN_BBNC_GETCOUNTRYADDRESSFORMATIDFROMCOUNTRYDESCRIPTION

Returns a country's address format for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@COUNTRYDESCRIPTION	nvarchar(100)	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCOUNTRYADDRESSFORMATIDFROMCOUNTRYDESCRIPTION
            (
                @COUNTRYDESCRIPTION nvarchar(100)
            )
            returns uniqueidentifier
            as
            begin
                declare @COUNTRYADDRESSFORMATID uniqueidentifier;

                if @COUNTRYDESCRIPTION is null or len(@COUNTRYDESCRIPTION) = 0
                    select
                        @COUNTRYADDRESSFORMATID = COUNTRY.COUNTRYADDRESSFORMATID
                    from
                        dbo.COUNTRY
                    where 
                        COUNTRY.ID = dbo.UFN_COUNTRY_GETDEFAULT();
                else
                    select
                        @COUNTRYADDRESSFORMATID = COUNTRY.COUNTRYADDRESSFORMATID
                    from
                        dbo.COUNTRY
                    where 
                        COUNTRY.DESCRIPTION = @COUNTRYDESCRIPTION;

                return @COUNTRYADDRESSFORMATID;
            end