SQL Server 2005

Saxitalis
Saxitalis used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Head of Software Services
Commented:
Hello Saxitalis,

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

Regards,

TimCottee

Author

Commented:
Perfect! Thank you sir

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial