Upper case in ALIAS for column Name not working

Question

In the following select statement firstname and Middlename ALIAS does not appear. I want this column header to be in Uppercase.

SELECT  dbo.Employee.Title AS SAL,
        dbo.Employee.FirstName AS FIRSTNAME,
        dbo.Employee.MiddleName AS MIDDLENAME
FROM dbo.Employee 

Answer 1

I have tried it and it works fine for me. However, here is a suggested change to your SQL which may assist.

SELECT Title AS [SAL],
       FirstName AS [FIRSTNAME],
       MiddleName AS [MIDDLENAME]
FROM dbo.Employee