How do I perform a GROUP BY on an aliased column in MS-SQL Server? - Stack Overflow

I'm trying to perform a group by action on an aliased column (example below) but can't determine the proper syntax. SELECT LastName + ', ' + FirstName AS 'FullName' FROM customers GR... ... Sorry, this is not possible with MS SQL Server (possible though .

stackoverflow.com