yep.See below illustrationDECLARE @Str varchar(8000)SET @Str='Table1.FieldA,Table2.FieldA,Table3.FieldC'SELECT REPLACE(CAST(XMLVal.query('data(/Root/Node/FieldName)') AS varchar(1000)),' ',',')FROM (SELECT CAST('<Root><Node><TableName>' + REPLACE(REPLACE(@Str,'.','</TableName><FieldName>'),',','</FieldName></Node><Node><TableName>') + '</FieldName></Node></Root>' AS xml) AS XMLVal)toutput---------------------------------FieldA,FieldA,FieldC
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/