How to concatenate two columns in SQL server 2008

Question

0.00/5 (No votes)

See more:

ItmsGrpCod(smallint)	ItmsGrpNam(nvarchar)
100	                 Items
101	                   Accessories
102	                 HP Printers
103	               IBM Printers
104	               PCs
105	               Servers

i need out put this..

100-Items
101-ACCESSORIES @ 5
102-AIRTEL DTH
103-AKSHAYA GRINDER
104-AMBAL GRINDER
105-ASAL INDCOOK
106-BAJAJ APPLIANCES

Posted 17-Apr-13 2:16am

DhananjayanP

Updated 17-Apr-13 2:36am

Maciej Los

v2

Add a Solution

3 solutions

Solution 2

Write sql query as below

SQL

select ItmsGrpCod +'-'+ ItmsGrpNam from TableName.

Posted 17-Apr-13 2:19am

Dnyaneshwar Kondbale

Comments

DhananjayanP 17-Apr-13 8:27am

it's having error Conversion failed when converting the nvarchar value 'Accessories' to data type smallint.

Solution 3

For MS SQL Server 2012 use CONCAT[^] function, for previous use "+": + (String Concatenation) (Transact-SQL)[^]

Some time, you need to use CAST and CONVERT[^] functions:

SQL

SELECT CONVERT(VARCHAR(30), ItmsGrpCod) + '-' + ItmsGrpNam AS [NewCode]

Posted 17-Apr-13 2:38am

Maciej Los

Updated 17-Apr-13 2:41am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Maxxx_ · Accepted Answer · 2013-04-17T02:18:00

Solution 1

select cast(itmsgrpCod AS VarChar) + '-' + itmsgrpNam

from tbl

I can't help but comment on the appaling column names on your tables though

What's wrong with ItemsGroupCode?

Posted 17-Apr-13 2:18am

_Maxxx_

Comments

Maciej Los 17-Apr-13 8:43am

Good answer, +5!
Please, see my answer. I had added some extra informations.