On 16/05/11 07:19, Dan McGrath wrote: > If you are using UniData you can create an I-type dictionary. > For the location (attribute 2 in the dictionary) put either > EXTRACT(@RECORD,2,2,0) or, alternatively, if you already have a D-Type > dictionary for the 2nd field (let us call it ADDRESS for arguments > sake), you could put EXTRACT(ADDRESS,1,2,0) > > Now, if we called the above dictionary item 'CITY', you can get your > required listing (sorted by CITY, ascending) by: > > LIST CLIENT CITY BY CITY > > If you are using UniVerse, this should be fairly similar.
In UV it should be even simpler ... :-) Assuming field 2 is called ADDRESS, you can create an i-descriptor with ADDRESS<1,2> in field 2. > > Regards, > Dan Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users