title: query to remove first value from " For XML PATH "
body: <p>i have a query like this :</p>
  
  <pre><code> Select ','''+ aa.KodeVerifikasi +''''    
   From TVerifikasiPOFakturHeader as aa (NOLOCK)        
   inner join TVerifikasiPOFakturDetail as bb (NOLOCK) on  aa.KodeVerifikasi=bb.KodeVerifikasi        
   Where aa.KodePO='TS/01/15/00183' 
   group by aa.KodeVerifikasi       
   order by aa.KodeVerifikasi        
   For XML PATH ('')  
  </code></pre>
  
  <p>and i get the return like this :</p>
  
  <pre><code>,'val6','val4','val5','val9'
  </code></pre>
  
  <p>but i want to remove first character "," and i want to get return like this :</p>
  
  <pre><code>'val6','val4','val5','val9'
  </code></pre>
  
  <p>when i using substring : SUBSTRING(','''+ aa.KodeVerifikasi +'''', 2, 8000) 
  i get return like this : 'val6''val4''val5''val9'</p>
  
  <p>please help me,,, and thanks...</p>