Thanks Dave & Lutz,

I got Solution...

Query has char(13) I'm using & also I did some properties set in front end grid.

Thank U very much...

But I want to show the 2nd column value in next line

Otherwise i want to show the differentiate 1st column & 2nd column value in single column..

Is it possible in...

Hi all,

Thanks for ur reply.

But i want following format O/P:

EmpNoFirstNameLastName

1Kumar Sen

2Roy ...

Hi all,

Thanks for ur reply.

But i want following format O/P:

Because I want to First column value is in top & 2nd column value is followed by Ist...

Thanks for your Reply ...

I want the result for above format..

because I need the 2 columns are show in a single column but the 2nd column value...

Thanks repton,

But I already tried this way.

But I need a single row with New Line in grid

|-----------------------------|

| ...

I used the following query...

Select 'chris'+ char(13)| + 'cintrella' as Name

But Its work in query result as text.

I used the following query...

Select 'chris'+ char(13) + 'cintrella' as Name

But Its work in query result as text.

plz. help me

Thanks for your Reply.

But I want to get from query O/P

then I need to fill in grid using .NET....