how to unite two columns [Resolved]

Posted by Oswaldlily under ASP.NET on 8/4/2011 | Points: 10 | Views : 1029 | Status : [Member] | Replies : 2
Column1-> A,B
Column2->123,456
column3->need to calculate using query so that my outout should be
A123,B456
Any idea?




Responses

Posted by: Hmanjarawala on: 8/4/2011 [Member] Bronze | Points: 50

Up
0
Down

Resolved
If you want to write this query in sql then Write this one:

select column1, column2, column1 + Convert(Varchar(3),Column2) As Column3 From Table

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nithadeepak on: 8/4/2011 [Member] Bronze | Points: 25

Login to post response