Adding Spaces in Between Columns

[renee35]

I am trying to export a flat file and the specs list location and length ex:
Location Length
1-2 2
3-4 2
10-18 9

How can I add spaces in between the 2nd and 3rd column to accomodate the gap from 5-9 in the location field. Also, is there a certain way to format to make sure the fields are in the right location.

Any help is much appreciated.

Thanks a bunch!!

-T

 

[RiverGuy]

Right click a column and choose the menu option to add a new one. You can resize it and leave it blank.

 

[renee35]

Will this be done in SQL? If so I tried to right-click it and adding a column and that isn't an option

Thanks a bunch!!

-T

 

[RiverGuy]

You are wanting the empty space in the Reporting Services report, or in the SQL query?

 

[MDXer]

Cast your columns in your query to fixed width data types.

Select
Cast(Col1 as char(2))
,Cast(Col2 as char(2))
,Space(5)+ Cast(Col3 as char(9))
From MyTable

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck