title: Finding the Differences Between 2 Columns, clarify
body: <p>As stated in this <a href="https://stackoverflow.com/questions/59457968/finding-the-differences-between-2-columns/63972587#63972587">question</a>
  Let's say I have data that looks like this:</p>
  <pre><code>Declare @YourTable table (ColA varchar(150),ColB varchar(150))
  Insert Into @YourTable values
  ('John, Sally','John, Sally, Cindy, Steve')
  
  Select A.*
        ,B.*
   From  @YourTable A
   Outer Apply (
                 Select Diff=value
                  From (
                         Select value=ltrim(rtrim(value)) From string_split(ColA,',')
                         Union All
                         Select value=ltrim(rtrim(value)) From string_split(ColB,',')
                       ) B1
                  Group By Value
                  Having count(*)=1
               ) B
  </code></pre>
  <p>you got</p>
  <pre><code>ColA                ColB                        Diff
  John, Sally         John, Sally, Cindy, Steve   Cindy
  John, Sally         John, Sally, Cindy, Steve   Steve
  </code></pre>
  <p>but how to get</p>
  <pre><code>ColA                ColB                        Diff
  John, Sally         John, Sally, Cindy, Steve   Cindy, Steve
  </code></pre>