1
Answer

Merge 2 column valuee is in single column but O/P is displayed some format

Ask a question

Hi all,
I want to merge 2 columns between Newline/Carriage return.
d.JPG
Because I want to First column value is in top & 2nd column value is followed by Ist column value on second line.
Both Column values are in Single Column.
I want to get from query O/P then I need to fill in grid using .NET....
 I used the following query...
Select 'chris'+ char(13) + 'cintrella' as Name
But Its work in query result as text not as table.
Please Give me a solution....

Answers (1)