Position variables in output using Query Analyzer 1

[deswalker]

Using Query Analyzer version SQL 8.00.194.
Help! I've created output that I need to send out in a .txt file. The file calls for variables to be at a specific position. example:
element length start end
------- ------ ----- ---
Name 60 1 60
line 1 61 61
product 1 62 62
...
How do I get the output formatted in a .txt with the exact position.
Thanks in advance

 

[SQLDenis]

convert to char with the length or use DTS

select convert(char(60),name),convert(char(1),line) etc etc

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/