>Does anyone know how to suppress the initial space in each line of output when doing a sql select to a text file? The same question goes for a LIST OFF to text as well. I could do a query to a cursor than a COPY TO file SDF but it seems like you should be able to get properly formatted output directly from the query.
I can't reproduce this behavior to test, but I have a suggestion to try. When printing a report to an ascii file, you can often remove blank lines from the output by setting the _ASCIIROWS down from 63 to something like 55. Worth a shot in your case.
Erik Moore
Clientelligence