>>Try this in VFP, can't test SQL at present.
>>

>>SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Clientxxx
>> FROM Client
>> GROUP BY Client.AI,clientxxx
>>

>
>This is not compliant in SQL Server.

-- T-SQL
DECLARE @Client TABLE (AI int ,Name varchar(200), Code char(6))

SELECT Ai, Clientxxx, MAX(Code) AS Code
FROM (SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Clientxxx, Code
             FROM @Client Client) Tbl1
GROUP BY AI,Clientxxx


*** VFP
CREATE CURSOR Client (AI int ,Name varchar(200), Code char(6))

SELECT Ai, Clientxxx, MAX(Code) AS Code;
FROM (SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Clientxxx, Code;
             FROM Client) Tbl1;
GROUP BY AI,Clientxxx