Charles, if your text file may be a XML file and You are using SQL 2000 you can use the clause:

FOR XML AUTO

at the end of your SELECT

sds

>Does anyone know if SQL Server can be programmed to create a text file from within a trigger or stored procedure. I searched BOL (ineptly probably) but a SQL equivalent to VFP's STRTOFILE() just didn't exist ;-) ...
>
>Thanks in advance,
>
>CT