How to Concatenate Strings That Have Trailing Spaces?

I am trying to export data from a SQLServer database into a text file using a stored procedure. I want to be able to read it and debug it easily; therefore, I want all the columns to indent nicely. This means I need to append trailing spaces to a text string (such as "Test1 ") or append leading space in front of a text string that contains a number (such as " 12.00").

Now, the stored procedure works fine when I run it in Query Analyzer. But it doesn't work correctly when I run it using ISQL - All the columns are not indented. I am wondering why it doesn't work in ISQL.

This is what I want, and this is also what I get when I run the stored procedure using Query Analyzer: Test1 , 2,Test1. Txt , 1.00, 1.00 Test22 , 2,Test22. Txt , , Test333 , 2,Test333.

Txt , 30.00, 30.00 This is what I get if I run the stored procedure using ISQL (isql -S myserver -E -w 556 -h-1 -n -d mydb -Q "exec MyTest"): Test1, 2,Test1. Txt, 1.00, 1.00 Test22, 2,Test22. Txt, , Test333, 2,Test333.

Txt, 30.00, 30.00 You ... more.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.