title: Replace the last item's comma separator with "and" in Sql STUFF Command
body: <p>If the output of my query is England, America, India.</p>
  
  <p>Is it possible to display the query result like England, America <strong>and</strong> India</p>
  
  <p>Here is my query: </p>
  
  <pre><code>Select stuff( ( Select Distinct ',' + Country as[text()] 
  from tbl_Country 
  where OrderNo in (Select Max(OrderNo) from Tbl_Literature where ID='AB123' 
                    Group By OrderNo) for XML path('') ),1,1,'')as Result 
  from dbo.Tbl_Master as TP 
  where 
    TP.OrderNo IN (select MAX(order No) from dbo.Tbl_Master where TP.ID = 'AB123') 
  </code></pre>