MEHA SHANMUGASUNDARA

MEHA SHANMUGASUNDARA

  • NA
  • 49
  • 106.7k

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

Jan 22 2010 12:40 AM

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)