mysql> delimiter @@
mysql> create table test (id int)@@
Query OK, 0 rows affected (0.06 sec)

mysql> insert into test values (1),(3),(2)@@
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from test@@select id,5-id id2 from test order by id desc@@
+------+
| id   |
+------+
|    1 |
|    3 |
|    2 |
+------+
3 rows in set (0.00 sec)

+------+------+
| id   | id2  |
+------+------+
|    3 |    2 |
|    2 |    3 |
|    1 |    4 |
+------+------+
3 rows in set (0.02 sec)

mysql> drop table test@@
Query OK, 0 rows affected (0.01 sec)

mysql> delimiter ;
mysql>

SELECT     empName, projIDs = replace
                          ((SELECT Surname AS [data()]
                              FROM project_members
                              WHERE  empName = a.empName
                              ORDER BY empName FOR xml path('')), ' ', REQUIRED SEPERATOR)
FROM         project_members a
WHERE     empName IS NOT NULL
GROUP BY empName