xxxxxxxxxx
--If 'AS' doesn't work to rename try this :
--Column is Varchar :
SELECT ColumnName+'' AS 'NEW NAME' FROM TABLE
--Column is int :
SELECT ColumnName+0 AS 'NEW NAME' FROM TABLE
--Column is Date :
SELECT isnull(ColumnName,'2023-04-26 00:00:00.0') AS 'NEW NAME' FROM TABLE --Do that if you are sure to not have any null result in the column