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 ?

Answer 1

Try like this:

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

SQL DEMO