SELECT CAST(dbo.Employees.HireYear AS nvarchar(4))
Convert Integer to String in SQL Server
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))
SELECT CAST(dbo.Employees.HireYear AS nvarchar(4))