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
SaxitalisAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Hello Saxitalis,

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

Regards,

TimCottee
0
 
SaxitalisAuthor Commented:
Perfect! Thank you sir
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.