Hello
 need to fix data for Persan name can you please help

Thank you for your help

WHEN a.[Person Email] IS NULL AND a.[person name] IS NOT null THEN
                  (   SELECT     TOP 1 Email COLLATE DATABASE_DEFAULT
                        FROM      [dbo].[vw_PersonEmail]
                     ...

if do select top 1, I get 1st email for person correct and the rest get email of that person, I need people have their emails mapped correctly.

Thank you,it works only if I run it outside of my statement,but if I run the full code 
Subquery returned more than 1 value. This is not permitted when the...

Thank you,it is working

 also trying to this select statement to email add this code:

WHEN a. [Person Email]  is NULL
  THEN (SELECT Email FROM [dbo].[PersonEmail]...

data was posted sorry

here is sample data

I found problem in email it goes like that:'%@rs.org
%'
eamplee:
( N'ba@rs.org
julia.leis@rs.org' )
 think split needs to be used by not sure i

how can this...

Hello

Thank you so much:
so it works for this:
"bassam.nasser@crs.org julia.leis@crs.org"
t doesn't work for this:

bass.nasr@rs.org julia.liii@rs.org

Can you please help?

it is not working for me and I am asking for help

(LEFT([Person Email],(CHARINDEX(' ',[Person Email])-1),REPLACE([Person Name] , '"', ''))

there is also there at the beginning and end  email ", after this code they were removed but how to remove on left side.

Thank you