SELECT

STUFF(

	(SELECT '^' + [필드] AS [text()]
	   FROM 
	[테이블] WITH (NOLOCK)										
	 FOR XML PATH(''))
 
 , 1, 1, '') AS [필드리스트]


많이 쓰는거라.. 메모해둠.. ㅎㅎㅎ