you could try
Code:
SELECT DISTINCT
UPPER(REQUESTER_F_NAME) AS Expr3,
UPPER(REQUESTER_L_NAME) AS Expr4,
UPPER(REQUESTER_SFID) AS Expr2,
max(REQUESTER_PHONE),
max(SUBSTRING(REQUEST_ID, 1, 2)) AS office,
max(REQUESTER_DEPT)
FROM
dbo.RH902
GROUP BY
UPPER(REQUESTER_SFID),
UPPER(REQUESTER_F_NAME),
UPPER(REQUESTER_L_NAME)
ORDER BY
UPPER(REQUESTER_SFID),
UPPER(REQUESTER_F_NAME),
UPPER(REQUESTER_L_NAME),
max(REQUESTER_PHONE),
max(SUBSTRING(REQUEST_ID, 1, 2)),
max(REQUESTER_DEPT)
if this doesnot work, can you give me an actual example of what the initial table looks like, ie data, and what you want to produce
