query to remove first value from " For XML PATH "

Question

i have a query like this :

 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 ('')  

and i get the return like this :

,'val6','val4','val5','val9'

but i want to remove first character "," and i want to get return like this :

'val6','val4','val5','val9'

when i using substring : SUBSTRING(','''+ aa.KodeVerifikasi +'''', 2, 8000) i get return like this : 'val6''val4''val5''val9'

please help me,,, and thanks...

Answer 1

USE STUFF

SELECT STUFF((
               your query here
             ),1,1,'')

Answer 2

Try this

select STUFF( (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 ('') ),1,1,'')