>>SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Clientxxx >> FROM Client >> GROUP BY Client.AI,clientxxx >>>
-- 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