Click here to Skip to main content
15,894,405 members
Search within:


how to concatenate two integer columns in Sql StoredProcedure?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL-Server
how to concatenate two integer columns in Sql StoredProcedure?
Posted
Add a Solution

4 solutions

SELECT CONVERT(VARCHAR, intfield1) + CONVERT(VARCHAR, intfield2) FROM sometable
 
Share this answer
 
Posted
Select cast(@Num1 as varchar) + cast(@Num2 as varchar)
 
Share this answer
 
Posted
See this query

.....

SQL
Declare @Num1 int,@Num2 int
set @Num1=50
set @Num2=100

select (convert(varchar,@Num1)+convert(varchar,@Num2)) as Sum


Nirav Prabtani

 
Share this answer
 
Posted
Updated 26-Mar-14 22:40pm
v2
Comments
Schatak 27-Mar-14 4:01am    
above query is not concatenating but adding
Nirav Prabtani 27-Mar-14 4:41am    
see updated solution above
select cast(1 as varchar)+ cast( 2 as varchar)
 
Share this answer
 
Posted
Add a Solution

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

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to concatenate two columns in SQL server 2008
how to concatenate two columns in sql server
How to concatenate two column values in dropdownlist
How to concatenate two columns in SQL server 2008
How to concatenate two columns in SQL server 2008
Concatenate 2 Strings
how to concatenate two columns in Dropdownlist asp.net c# sqlerver
Concatenate new digit with all exist values in specific column
How to add order by in string agg, when two columns are concatenated.
Sql concatenate column in SQL server

Advertise
Privacy
Cookies
Terms of Use
Last Updated 8 Apr 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900