Sql concatenate integer columns to string

Question

I have two int columns in my table.

I want to concatenate them like a string

for example : A = 12345 , B = 2

I want to return 123452.

How can I do that ?

But why do you want to do that?!? First cast to char, then concat. — jarlh
– jarlh, Commented May 25, 2015 at 9:29
possible duplicate of stackoverflow.com/questions/19067649/… — ughai
– ughai, Commented May 25, 2015 at 9:54

Rahul Tripathi · Accepted Answer · 2015-05-25 09:30:44Z

5

Try like this:

select CAST(A as varchar(10)) + CAST(B as varchar(10))

SQL DEMO

answered May 25, 2015 at 9:30

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

BrMe Over a year ago

I did this, but it make my query slow, do u have a quicker query to do that?

Rahul Tripathi Over a year ago

@BrMe:- I think you are running a different query then the one which I posted. What is the query which you are trying and which is taking time? Also the above query is quick enough, I dont think that you can achieve this any more faster than this.

S.Krishna · Accepted Answer · 2015-05-25 09:31:41Z

0

You can use something like below

SELECT NUMBER_COL1,
       NUMBER_COL2,
       CAST(NUMBER_COL1 AS VARCHAR(10)) + CAST(NUMBER_COL1 AS VARCHAR(10)) JOINED_NUM
  FROM TABLE;

answered May 25, 2015 at 9:31

S.Krishna

87612 silver badges26 bronze badges

Comments

Hell Boy · Accepted Answer · 2015-05-25 09:33:48Z

0

Use This Code:

declare @a int
declare @b int

select @a='12345'
select @b='2'

select cast(@a as char(10))+cast(@b as char(10)) as Concatenation

answered May 25, 2015 at 9:33

Hell Boy

9812 gold badges13 silver badges29 bronze badges

Comments

David Isla · Accepted Answer · 2015-05-25 09:41:15Z

0

But you can use math functions too. For example, in ORACLE SQL:

SELECT A * Power( 10, Length(B) ) + B FROM DUAL;

answered May 25, 2015 at 9:41

David Isla

6297 silver badges20 bronze badges

Collectives™ on Stack Overflow

Sql concatenate integer columns to string

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related