Join numbers in sql server 2008 stored procedure

Question

0.00/5 (No votes)

See more:

How do you join numbers in sql server 2008

example

SQL

SET @FIRSTNO= 400

SET @SECONDNO=12


SET @JOINNO= FIRSTNO+''+SECONDNO

expectation         =40012

is the above the right way

Please advice

Thanks

What I have tried:

I have checked my own programs and the internet
(shouting removed)

Posted 7-Mar-16 3:58am

Member 10744248

Updated 7-Mar-16 4:33am

Herman<T>.Instance

v3

Add a Solution

Comments

Herman<T>.Instance 7-Mar-16 10:01am

SET @JOINNO = @FirstNo * 100 + @SecondNo

2 solutions

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)

OriginalGriff · Accepted Answer · 2016-03-07T04:27:00

If you want a string result:

SQL

DECLARE @FIRSTNO INT
DECLARE @SECONDNO INT
DECLARE @JOINNO VARCHAR(MAX)
 
SET @FIRSTNO= 400
SET @SECONDNO=12

SET @JOINNO= CAST(@FIRSTNO AS NVARCHAR) + CAST (@SECONDNO AS NVARCHAR)

If you want an integer:

SQL

DECLARE @FIRSTNO INT
DECLARE @SECONDNO INT
DECLARE @JOINNO INT
 
SET @FIRSTNO= 400
SET @SECONDNO=12

SET @JOINNO= CAST(CAST(@FIRSTNO AS NVARCHAR) + CAST (@SECONDNO AS NVARCHAR) AS INT)

ZurdoDev · Accepted Answer · 2016-03-07T04:29:00

Solution 2

If they are of INT type then you would want to convert to VARCHAR() first otherwise they will be added (as in Math addition). For example:

SQL

DECLARE @First INT, @Second INT
SELECT @First = 1, @Second = 2
SELECT CONVERT(VARCHAR(50), @First) + CONVERT(VARCHAR(50), @Second)

Or you could use CONCAT()

SQL

SELECT CONCAT(@First, @Second)

which will convert them to strings for you.

Posted 7-Mar-16 4:29am

ZurdoDev

Comments

jaket-cp 7-Mar-16 11:20am

Just a small point, the CONCAT function becomes available in SQL Server 2012+

ZurdoDev 7-Mar-16 11:23am

Good catch. I thought it had been there for a long time.

jaket-cp 7-Mar-16 11:25am

It sticks in my head as the first time I saw it, I was using 2008 to try it out, with no luck :)