CHAR (Transact-SQL)

... SQL Server (SQL Server 2008 through current version), Azure SQL Database. Transact-SQL Syntax ... -- Create variables for the character string and for the current -- position in the string. DECLARE @position int, @string char(8); -- Initialize the cur

msdn.microsoft.com