How to concatenate two columns in SQL server 2008

Question

2.78/5 (4 votes)

See more:

SQL-Server-2008

Ho to concatenate two columns in SQL Server 2008.

Example Below
-------------

ID(int)     Year(int)     
-------     ---------
10           2008
20           2009
30           2010

Output should come as below

ID_Year (Output)
-------
10-2008
20-2009
30-2010

How to query in SQL Server 2008.

Posted 3-Jan-12 20:37pm

gani7787

Updated 1-Dec-19 23:27pm

Mehdi Gholam

v2

Add a Solution

6 solutions

Solution 3

Try also

SQL

SELECT (ID + '-' + year) AS ID_Year
FROM tablename

Posted 3-Jan-12 20:55pm

RaviRanjanKr

Comments

Member 11149016 17-Dec-15 4:10am

It throws error . it asks for conversion of datatype between two columns

Solution 4

u can use Sql Query like:-

select cast(id as varchar)+'-'+ cast(year as varchar) as ID_year

Hope, this will help you...

Posted 9-Dec-13 19:43pm

Jain Nishant

Updated 10-Dec-13 18:02pm

v2

Comments

CHill60 10-Dec-13 7:33am

It is better for you to vote for the solution than posting a comment as a solution in its own right. You will only attract downvotes and reports

Jain Nishant 11-Dec-13 0:03am

Now, u can vote for me....

Solution 2

SQL

select distinct cast(ID+ '-' + Year as varchar(100)) as newcolumn from tablename

Posted 3-Jan-12 20:51pm

devbtl

Updated 4-Jan-12 12:33pm

v2

Comments

anghan22 27-Apr-13 0:16am

i want to string and int concat plz give me..
soluction

e.g

KK-2
AA-3

above look like...

Solution 5

VB

SELECT Title,
FirstName,
lastName,
ISNULL(Title,'') + ' ' + ISNULL(FirstName,'') + ' ' + ISNULL(LastName,'') as FullName
FROM Customer

Posted 20-Dec-14 2:27am

User 7511078

Solution 7

select ID || '-' || Year as ID_Year from tablename

Posted 1-Dec-19 23:27pm

Member 14675097

Comments

CHill60 2-Dec-19 8:41am

Post is clearly tagged as SQL Server 2008. You have supplied a solution that is not relevant to that environment (i.e. you have used the concatenation operator for postgres or Oracle (amongst others). You should also take care as (unless configured otherwise) || means "logical or" which could lead to some unexpected results.
Usually best to stick with standard Transact-SQL

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)

Mehdi Gholam · Accepted Answer · 2012-01-03T20:44:00

Solution 1

Use the following :

SQL

select Convert(nvarchar(50),ID)+'-'+Convert(nvarchar(50),Year) as ID_Year from tablename

Posted 3-Jan-12 20:44pm

Mehdi Gholam

Comments

Elaa_zx 8-Nov-14 22:07pm

How to concatenate multiple tables into a single table(every table has the same column name)in SQL server 2008

Bebosh 18-Jan-15 4:57am

Yes, this is what I want .. Million thanks