0

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

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by Pgmer
0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.