none
Display rows and columns

Answers

  • Are you looking for the below: If not, pleas eprovide table structure and desired output.

    create Table T1(Col1 int, Col2 int, Col3 int)
    Insert into T1 Select 1,2,3
    Insert into T1 Select 1,2,3
    Insert into T1 Select 1,2,3
    
    Select CAST(Col1 as varchar(10))+CAST(Col2 as varchar(10))+CAST(Col3 as varchar(10))
    From T1
    
    Drop table T1


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Thursday, October 03, 2013 6:37 AM

All replies