How to combine two columns to single column in sql or oracle?

Posted by Sheeba under ASP.NET on 4/5/2011 | Points: 10 | Views : 10948 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi

I have 2 columns like Name,No..

I want these two columns values under a single column..

EX:

Name No

x 101

Details -- columnname - i want like this
*******
x 101

Hw to do?

Reply me soon...

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Prathibaramana on: 4/5/2011 [Member] Starter | Points: 25

0	Hi Chk whether is this useful : select convert(varchar,No) + Name as Details from tablename Sheeba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Manishsoni on: 4/21/2011 [Member] Starter | Points: 25

0	Hi, For MS-Sql Select Convert(Varchar,No) + Name as mergefield from tablename For Oracle Select No \|\| Name as mergefield from tablename Sheeba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Thanu Mon on: 8/27/2014 [Member] Starter | Points: 25

0	SELECT Name+ CONVERT (varchar, No) AS Details FROM tablename .... it is correct form.. Sheeba, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naveenhcl on: 9/3/2014 [Member] Starter | Points: 25

0	Hi, When you perform concatenate the 2 columns you need to check that 2 columns datatypes has been same or not. If that is differ then you need to convert it into as per your desired format. select col1+' - '+col2 from tablename Sheeba, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts