title: How to include an OR condition into Exists?
body: <p>I want to select a name and a year. Why I get both year although I select 2020?</p>
  <pre><code>CREATE TABLE [dbo].[Person_Table]
      (
        Person nvarchar(500) NULL, 
        Name2 nvarchar(500), 
        Year_N int
      ) ON [PRIMARY]
  
  INSERT INTO Person_Table (Person, Name2, [Year_N])
  VALUES ('Ken,Brian,Mike,','A,B,','2000'),
         ('Mikem,Briane,Kenny,','C,D,','2020'),
         ('Dodo,Chris,Mike,','A,B,','2020');
  
  -------------------------------------------------
  DECLARE @Person NVARCHAR(100) = 'Mike',
          @Date int = 2020
  
  SELECT *
  FROM [dbo].[Person_Table]
  WHERE EXISTS 
                (Select * from string_split(Person,',') 
                 WHERE value in (@Person))
                
  OR EXISTS     (Select * from string_split(Name2,',') 
                 WHERE value in (@Person))
  
  AND Year_N = @Date
  </code></pre>
  <p>Microsoft SQL Server 2019</p>