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 |  
                                    | jassieConstraint Violating Yak Guru
 
 
                                        332 Posts | 
                                            
                                            |  Posted - 2013-11-03 : 11:21:43 
 |  
                                            | 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 number2. 5 spaces3. company number that is varchar(5)4. 5 spaces5. company name6. 5 spaces7. 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? |  |  
                                    | visakh16Very Important crosS Applying yaK Herder
 
 
                                    52326 Posts |  |  
                                |  |  |  |