This is how to convert an integer to string in SQL SERVER. Let’s suppose we want to present the year as a string

SELECT CAST(dbo.Employees.HireYear AS nvarchar(4))

convert integer to string