[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

SQL Server 2005

Hello Experts,

Does anyone know how to concatenate two integer columns from the same table without adding them?

I tried this but it  adds the integers together rather than concatenating them:
SELECT IntA + '' + IntB From Table1

Thanks
0
Saxitalis
Asked:
Saxitalis
1 Solution
 
TimCotteeCommented:
Hello Saxitalis,

Select Cast(IntA As Varchar) + Cast(IntB As Varchar) From Table1

Regards,

TimCottee
0
 
SaxitalisAuthor Commented:
Perfect! Thank you sir
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now