Hi All,

SELECT
            'Name A ' as Column0, 
		Some column  as Column2,		
	      FROM  MyTable
WHERE 	my condition

UNION 

SELECT 
	       'Name  B' as Column0, 
		Some other column  as Column2,		
	      FROM  MyTable
WHERE 	my condition

I want to concatenate the rowNumber with column0 any idea how to do that?

Thanks & Regards,
Vadiraj

union works only when both the tables havin same structures

Hi Anuj.. Thanks..
I found the sollution for my problem.
:)