Hi @ll, I'm trying to extract data from a database where columns have names with spaces inside, I show an example:

select "total amount"
from sales;

This query shows me all data stored in the "total amount" column in table sales, ok no problem.

Well, the problem comes when I try to execute this query with osql because the output text file where I put the data only have the text "total amount".

I use the query as I wrote before stored in a text file.

I'm doing something like this:

osql -U user -P passwd -i query.sql -o textfile.txt

Can anybody give a hand? What I'm doing wrong?

Thank you in advance.

Bye.