Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-16 : 09:09:43
|
| Lance writes "I want to export data to a text file. The text file has a fixed lenght of 300. Tha data being exported is not 300 long and can vary in lenght. I need to pad the remaining lenght with blank characters. Any ideas on how to do this? Thanks for any help you can provide." |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-16 : 09:13:42
|
| Can you post the query that you plan to execute in dts or in your stored procedure.You can probably use the STUFF function which can be found under string functions in BOL. |
 |
|
|
|
|
|
Exporting data