UFN_BUILDFULLADDRESS

CREATE function dbo.UFN_BUILDFULLADDRESS(@ADDRESSID uniqueidentifier, @ADDRESSBLOCK nvarchar(150),    @CITY nvarchar(50),    @STATEID uniqueidentifier,    @POSTCODE nvarchar(12),    @COUNTRYID uniqueidentifier) returns nvarchar(300) with execute as caller
/*This code was auto-generated by calling dbo.USP_CREATEORUPDATE_BUILDFULLADDRESS on Nov 11 2014  4:23PM.  */
 as begin
declare @COUNTRYADDRESSFORMAT uniqueidentifier
/*if @COUNTRYID is null*/
/*get default country for system?*/
/*based on country figure out how to format the address*/
set @ADDRESSBLOCK = coalesce(@ADDRESSBLOCK, '');
set @CITY = coalesce(@CITY, '');
set @POSTCODE = coalesce(@POSTCODE, '');
select @COUNTRYADDRESSFORMAT = COUNTRYADDRESSFORMATID from dbo.COUNTRY where ID = @COUNTRYID

if @COUNTRYADDRESSFORMAT = '8472DB8F-EC57-4295-8B8F-B655BC7F4A26'
return dbo.UFN_ADDRESS_FORMAT_US(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '959809FB-8FA7-4A19-888F-9951BD9B29D3'
return dbo.UFN_ADDRESS_FORMAT_UK(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'D473071F-DFF5-4F8D-8E4B-D90CB806D950'
return dbo.UFN_ADDRESS_FORMAT_CA(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'B56E02E7-B334-44F8-B2F0-1E8F1BC59CAB'
return dbo.UFN_ADDRESS_FORMAT_AU(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'A3B050A5-E1C8-4E1B-99AE-40E9FCADA0BC'
return dbo.UFN_ADDRESS_FORMAT_NZ(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '0EC8E67B-BCD3-4BA0-9558-F01EBC7C4EC1'
return dbo.UFN_ADDRESS_FORMAT_IN(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'DAAA6D4A-5959-489E-A647-FC3D30EB887C'
return dbo.UFN_ADDRESS_FORMAT_PRC(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'D0E26213-45EA-41C1-9EB2-EC2AE7E2EF16'
return dbo.UFN_ADDRESS_FORMAT_9EB99D99B5AB4389BEB2E4E07CC8B638(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '3B468B56-99B4-4CD9-B96A-0B9CBD19868E'
return dbo.UFN_ADDRESS_FORMAT_A99D649246594A13A7315F4C504FA773(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '143D9823-CB51-4E31-8C6D-60C7DC97A2C3'
return dbo.UFN_ADDRESS_FORMAT_9E4E11369CA645F497FF5A946EAD1060(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'F6BCF953-1323-4C44-A6C9-D8446870ED1A'
return dbo.UFN_ADDRESS_FORMAT_40669D39E8DA47A6A35B7EB3DBD2EBD4(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '0579D305-2816-4BB4-951F-7205FC65DD4B'
return dbo.UFN_ADDRESS_FORMAT_796D7C63659E42F39C5FC74F26078024(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'B301F83D-B87A-4E89-848E-78921179C740'
return dbo.UFN_ADDRESS_FORMAT_FBE04EA577B8450E979C4276E16D292B(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '2F435D7B-5778-4CEE-9A63-70A23A8BB931'
return dbo.UFN_ADDRESS_FORMAT_6F97F7454C7A4278B3C917BA702BA31E(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '6E5C5205-CDE8-4CA1-9FD8-1055A8E42DD3'
return dbo.UFN_ADDRESS_FORMAT_B539C69F426745A980D7186A0303A645(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '7ADA7F55-40D0-4D89-A128-1CBB8AC22A18'
return dbo.UFN_ADDRESS_FORMAT_A580EE4FA17948DDAC7A93166065829D(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'C199450E-F8F5-40F4-9167-B0BBB5949EBE'
return dbo.UFN_ADDRESS_FORMAT_C12F2C317D074C5F8AF83932255F9642(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '39E43D78-9785-402C-B857-EF639D1C8860'
return dbo.UFN_ADDRESS_FORMAT_96C33DF5572242E59DA24CC44E185277(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'D10A9239-04D4-451C-A2CC-C29BD83A0ED7'
return dbo.UFN_ADDRESS_FORMAT_8B7A12F48FE24C1DA726A43F67763E61(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '9603C669-9F22-4374-9F2E-9CABFB8222B6'
return dbo.UFN_ADDRESS_FORMAT_462623AC9E8A4B398544015DC6F031A3(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'AE1707B7-DCA4-42EE-96DA-EAF12980DBBF'
return dbo.UFN_ADDRESS_FORMAT_6735368C963142B3A170B716F32A071E(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '7E2F21CE-43D2-4E51-AEA9-E6A8689E5DCD'
return dbo.UFN_ADDRESS_FORMAT_9DD2381BC660449989B33F20987D62AB(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '5B099495-CDB0-4A90-A516-03C8094FA8F0'
return dbo.UFN_ADDRESS_FORMAT_24EAA475181C48DE80D1924912733035(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '237E6383-6861-4B2E-A554-857001FDF1B9'
return dbo.UFN_ADDRESS_FORMAT_3B9E369966494E18B7C140994CC38264(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '100598CA-20C5-4AC1-B9D2-1D1F5B375B71'
return dbo.UFN_ADDRESS_FORMAT_24031377BFAF409ABAB9D018CE3E1743(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'E4FA6D01-DB1F-426D-9512-B44D5C80CA77'
return dbo.UFN_ADDRESS_FORMAT_89765C94D54444A291C338F774F3B981(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'C7C0E4F0-DECE-47C9-B625-9EF5210FD2D8'
return dbo.UFN_ADDRESS_FORMAT_06839EF981144AF9AD0485E3C71B4702(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '0800E466-3CB3-42C8-AFE4-3D20578A8A65'
return dbo.UFN_ADDRESS_FORMAT_BDC6003201AB479D97E2769DB7E8E6AC(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'E01DA4E1-C659-419F-9B5B-C6E4FABBE193'
return dbo.UFN_ADDRESS_FORMAT_AFC89E74E1C14F84A3E04587B9A5F466(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '00273317-7DA8-4B54-A8CB-7F23125DDBBB'
return dbo.UFN_ADDRESS_FORMAT_7A76C8AC4D4B41E089E9D40E59C7E754(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '6B0A5337-6E78-47F7-9A20-38982A144DA2'
return dbo.UFN_ADDRESS_FORMAT_67D2461BDE9C42D8AC8EFB4363827C90(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'CB2C4AD3-4C74-4A2E-B53B-F5ADA25A56A0'
return dbo.UFN_ADDRESS_FORMAT_23CBA5DB8E0A4686B4CA12BC07CBC03C(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '7EBE29CF-8198-49B4-B462-A6B7136A7DC8'
return dbo.UFN_ADDRESS_FORMAT_40423178A1BA4BBEA27E9D1198771542(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'FDC8E542-D32F-43C8-81E8-6182AC97C172'
return dbo.UFN_ADDRESS_FORMAT_5408D7CB2F8E43C99171FD0FB46BB759(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '976EF201-9AD2-4ACD-8826-50E91FEA79DA'
return dbo.UFN_ADDRESS_FORMAT_B636134848CD47E09BCCEF99B8B26297(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'BAC051C1-41AD-4327-98D0-DAC10E309A07'
return dbo.UFN_ADDRESS_FORMAT_BD777294CC604606AB15D9D87F6B4B07(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '9D9AB6F8-A3F4-4649-ABCC-FE80EE58D89B'
return dbo.UFN_ADDRESS_FORMAT_0C9097D7EE98407F95CF09243EFA7B53(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'E7F42282-28E0-446E-9508-CEDD8C1BB40A'
return dbo.UFN_ADDRESS_FORMAT_C4D37CA3C6EC428593EC7CFE1DBFDC9F(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'F8719DDE-99DB-45A4-9F72-63177ECBB956'
return dbo.UFN_ADDRESS_FORMAT_ADA3619F86A54584AB86D73C74CD48BF(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '98C7811F-9164-47F4-BDA7-AC2245788F09'
return dbo.UFN_ADDRESS_FORMAT_C9B64242E4164E62BB294132CD343CE5(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'D52503CF-1B63-4BBF-8012-E257DF891B01'
return dbo.UFN_ADDRESS_FORMAT_1C621D3BA10947E8A16B519DB49BA5C7(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '15FD1897-B8E2-45DD-BCF1-62624D2CEF2D'
return dbo.UFN_ADDRESS_FORMAT_C6409087F1204F9798609D70FBCE17E9(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '99237F7C-27BC-405B-B39B-51DD292E92A7'
return dbo.UFN_ADDRESS_FORMAT_A51EC61F93154A72A5479ADC325D2574(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '88243FE7-30BB-4B13-A78C-6C97DEF38848'
return dbo.UFN_ADDRESS_FORMAT_CCFF7E4D282644478ED9DF11E6119745(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '33F3E157-ADCF-4990-871A-4E7CE3464BF4'
return dbo.UFN_ADDRESS_FORMAT_E6371DEA50264268BFF15EC21560C41A(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'F790D5F4-C5CD-428D-8BB1-85A78B00CED0'
return dbo.UFN_ADDRESS_FORMAT_337D2C159FE141CDA78A8F9A9C6EAB5C(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '1E3009B1-9C41-45E3-990F-F660ECCC8B42'
return dbo.UFN_ADDRESS_FORMAT_ADC8B5FC09DE4657A34F964D5C73267E(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '9BBFF7B0-8F6A-4074-A172-2577B06D3240'
return dbo.UFN_ADDRESS_FORMAT_BCE5EC5BFA46491DB3150EBD0C303E17(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '750DA1FF-C884-4B3A-94A2-8A9D6DCD8563'
return dbo.UFN_ADDRESS_FORMAT_447B5332FC5F4D8CB878457F2CFF43BE(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '65381E4B-0698-46F2-BF52-17E81AC4F7D5'
return dbo.UFN_ADDRESS_FORMAT_0AF078E07349464988960BAFA67A71BB(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '9F222715-A18C-40EA-90C5-97F50DC5EDCB'
return dbo.UFN_ADDRESS_FORMAT_14F296415E674306A1507E6D6551A99A(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '59E5FD30-C958-428D-9D6C-EFEAFDBFFA35'
return dbo.UFN_ADDRESS_FORMAT_0110D3D2ED9C4DB4A3BBA519446E3F86(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'C9942583-3556-43D3-A6D7-BEFFCDA7EBB3'
return dbo.UFN_ADDRESS_FORMAT_8F15CAF898F4406990031901553F5CA7(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '0DD83C8E-FD35-4F1D-A1FC-E80FC659D69E'
return dbo.UFN_ADDRESS_FORMAT_7442A811E34940ACB6AD2094E3818C3A(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '21022C2C-A769-498A-9BEF-B38316763C27'
return dbo.UFN_ADDRESS_FORMAT_9809FE899C704CD4B99D90F42A3CF30A(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '16BA4AF5-22EA-4B06-86F4-0B0ECE3AB908'
return dbo.UFN_ADDRESS_FORMAT_119455CF8E3644FF9372C5EEDB9AC104(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'C552DD08-3E3E-412E-8E0C-E0E4A8BD287C'
return dbo.UFN_ADDRESS_FORMAT_CD80B305CF9C42D787ADF4F6EAC1C0BA(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'E393E8DB-A66E-4F13-B23B-7A3ECFDE0768'
return dbo.UFN_ADDRESS_FORMAT_4FF56B5CE98D454CA0FFFB01D9CB36AB(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '52C9DEE5-61E2-480F-9F0E-630BECF3BCAF'
return dbo.UFN_ADDRESS_FORMAT_1DE893532B71468EB262B4A5E524525D(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '945FF4A8-0A7D-4A5F-9B12-EB93ED8EF571'
return dbo.UFN_ADDRESS_FORMAT_2D9E4E3364AC47C0BC11836175CEC807(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '3B4FF4DC-24C2-4503-B526-008AA4CC6A18'
return dbo.UFN_ADDRESS_FORMAT_B6F045BF02A5490CB1A0A61BBD819C54(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '0D6622E0-F2B2-44F8-A903-5871BF6824AB'
return dbo.UFN_ADDRESS_FORMAT_963D30A1875F4A0DBA6F450C6659D738(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'EDC59A48-828B-4FEF-A57F-CBF61B561577'
return dbo.UFN_ADDRESS_FORMAT_2EB3C75272084C33A7FFE597CE6B6469(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '7D533115-5FE6-4C67-B09E-E800AD90FF59'
return dbo.UFN_ADDRESS_FORMAT_2660992D59944D2BABE8291720F89827(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'B5C7E3BF-ED38-466C-8D16-B364A3179F08'
return dbo.UFN_ADDRESS_FORMAT_936841F1697E47E98305A8922846FAF3(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '9B3C33C2-9739-46D3-A516-3A53475C7852'
return dbo.UFN_ADDRESS_FORMAT_9B195B3988D6413693D85A2D8E45E5A9(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '6C4FE49E-8AFC-4044-A1B0-AEB29C9A64F3'
return dbo.UFN_ADDRESS_FORMAT_573DFE1C46D741BFB6D55F916CAA6842(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '1B8EFB0B-A297-4E6F-8C4A-9A522A8DB736'
return dbo.UFN_ADDRESS_FORMAT_8361474B71244BDFBE6F2DF61964BE82(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'ABEA19FB-6B72-436F-9A46-88A6DE3D5D2F'
return dbo.UFN_ADDRESS_FORMAT_41C5BA7A8C404D36A456CB1C62CD631D(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'F6ED57FC-C6CD-41A2-BFE0-4BEE8D8529C1'
return dbo.UFN_ADDRESS_FORMAT_AA5CCDD675B943979F2888C03DF0A103(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '602DEE5F-A5A2-4662-9A0B-F114C5977AF3'
return dbo.UFN_ADDRESS_FORMAT_851B0C27D8914321820C566B2EF50173(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '78F9D4DD-B933-46B9-8774-03073E93D22E'
return dbo.UFN_ADDRESS_FORMAT_7FE1C49CC02341C3AFC0A84ED56AB542(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'D724DB14-0089-43AB-BA60-3E222523E6FD'
return dbo.UFN_ADDRESS_FORMAT_9A5056DD0A5444E2BF9EC882CFB4FBBB(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'EE7C0BDC-15FC-457B-8595-33D87960758C'
return dbo.UFN_ADDRESS_FORMAT_0E69A2DC4EA94F50851EF48CB3F68177(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '1A8909BD-1874-4525-8672-6BD9F314D575'
return dbo.UFN_ADDRESS_FORMAT_7EBC34B9029541179B7BD66C6350048A(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'AE1D3E38-A029-4FE5-9F23-AEAD80F0C9A9'
return dbo.UFN_ADDRESS_FORMAT_113C0EA9380B48D8833B875DBEE95B6E(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'DA283165-6214-4C51-8733-76B31EFEA52E'
return dbo.UFN_ADDRESS_FORMAT_C46FA5D9D1D34B0C96804C497A094E7C(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'F860EA5B-C4D9-4B18-A3D7-24B250FE669B'
return dbo.UFN_ADDRESS_FORMAT_7EAD488C90454CA18C6DC8A7DCC416EB(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'CA7E8FDF-6950-4EF6-8F55-D4D0D187B575'
return dbo.UFN_ADDRESS_FORMAT_4DACF1F8DF9642778F4192C6878C09D5(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '34A162D8-0D8A-4167-A34E-5DB1ED14F098'
return dbo.UFN_ADDRESS_FORMAT_E6E77A5971514667A800223E69B9E11C(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '37B865DC-8DA7-4F79-B9B9-E8C626D9EF74'
return dbo.UFN_ADDRESS_FORMAT_1E45C1CE396A4B5F9CFF86740E40A5B4(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = '3C8E41C7-9786-4BCC-A450-59FC1ED4CBBE'
return dbo.UFN_ADDRESS_FORMAT_B6E92EB3899449378E079DC0D09C0682(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

if @COUNTRYADDRESSFORMAT = 'C7653F01-F44F-4A41-8050-4CC055B9576D'
return dbo.UFN_ADDRESS_FORMAT_5366B0F48D014D98A5ADAF25DAEAE7FC(@ADDRESSID, @ADDRESSBLOCK,@CITY,@STATEID,@POSTCODE,@COUNTRYID)

return ''
end