Problem with concatenated fields in SQL server

[herci]

Hi.. I'm kind of new using SQL Server,

I have a problem, I did a query and I needed to concatenate many of the fields, when i ran this query in the query analizer it was fine.. but i need to run it in command line because I need to save the result in a .txt file.. but the issue is that with this concatenated fields the results generate some spaces before an after the field in the .txt field.


How can I eliminate this blank spaces from the output?

 

[ColinM]

use the trim functions:

SELECT LTRIM(RTRIM(col))

 

[ronnetp]

I would suggest you use DTS if you need to export some data to text, is the most complete tool I have found to export and import data with simple to complex situations.