>=StrToFile( @TextList, ‘c:\temp\List.Txt’) >There's no simple way to write to text file in SQL Server. Take a look at http://www.umachandar.com/technical/SQL2000Scripts/UtilitySPs/Main7.htm and http://mysite.freeserve.com/nigelrivett/WriteTextFile.html.