Concatenating int and nvarchar column in

Concatenating int and nvarchar column in

SELECT CAST(RegID.ID as nvarchar(5)) + ' - ' + CAST(FirstName.Name as nvarchar(max)) AS Name
FROM Details

2020-05-05