UFN_WEALTHPOINT_CONSTITUENTSEARCHADDRESSESXML

create function dbo.UFN_WEALTHPOINT_CONSTITUENTSEARCHADDRESSESXML(@ID uniqueidentifier)
returns xml
with execute as caller
as begin
    -- do work here and return a value


  return  (
    select
      nullif(dbo.UFN_ADDRESS_GETADDRESSLINE(1,A.ADDRESSBLOCK),'') as CS_ADDRLI1,
      nullif(dbo.UFN_ADDRESS_GETADDRESSLINE(2,A.ADDRESSBLOCK),'') as CS_ADDRLI2,
      nullif(dbo.UFN_ADDRESS_GETADDRESSLINE(3,A.ADDRESSBLOCK),'') as CS_ADDRLI3,
      nullif(A.CITY,'') as CS_CITY,
      nullif(dbo.UFN_STATE_GETABBREVIATION(A.STATEID),'') as CS_STATE,
      nullif(A.POSTCODE,'') as CS_ZIPCODE
       from [dbo].[UFN_WEALTHPOINT_CONSTITUENTSEARCHADDRESSES](@ID)  SEARCHADDRESS
    left outer join dbo.ADDRESS A on A.ID = SEARCHADDRESS.ID
    for xml raw('Address'),type,root('root')
    )

end