In an sql server 2008 r2 report, I have one textbox that I need to concantenate values together. I then need to concatenate the values together to display in one cell that looks like the following:
1. Company number
2. 5 spaces
3. company number that is varchar(5)
4. 5 spaces
5. company name
6. 5 spaces
7. company number that is varchar(30).
Thus can can you show me how to display the values in the order the customer wants to see them in the one cell?