Spaces in my .CSV file

[ringworm24]

Hi,

I have an automated report which has lots of unwanted spaces in in it and a few empty rows at the EOF. When I run the report from Query analyzer and save as csv it has no spaces, where is the auotmated report getting the spaces from and how can I stop this? Many Thanks

 

[SQLDenis]

you can use rtrim(field) around all your char fields

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/