concat two integers and result as string in SQL

Question

In table, 2 fields ID as int and Number as small int and i want to concatenate the two fields and display as string

eg: ID = 101 and Number = 9 
output : 101.9 

Dot to be added in between ID and Number? How to query in SQL?

Answer 1

You can CAST your integer field to varchar and then concatenate them as you want.

DECLARE @ID INT 
DECLARE @Number INT 

SET @ID = 101 
SET @Number = 9  

SELECT CAST(@ID AS VARCHAR(10) ) +'.'+ CAST(@Number AS VARCHAR(10) )