UFN_WEALTHPOINT_CONSTITUENTSEARCHEMAILADDRESSESXML

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


  return  (
    select top 5
      EMAILADDRESS 
    from EMAILADDRESS 
    where CONSTITUENTID = @ID 
    order by ISPRIMARY desc, DATEADDED desc
    for xml raw('EMAILADDRESS'),type,root('root')
    )
end