title: How can I get distinct values in COALESCE()
body: <p>I have table values in this format</p>
  
  <pre><code>sam
  jack
  sam
  john
  
  Declare @name varchar(max)
  select @name = COALESCE(@name + ', ','')+ user_email 
  from   PostedCommentMaster where article_id = @id
  </code></pre>
  
  <p>How can I get distinct value</p>
  
  <pre><code>sam,jack,john
  </code></pre>
  
  <p>like this.</p>