Select distinct colname from table_name where "you prefer" 8Besides I often use tally to determine how many duplicates I have in a field)
Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 S-131 30 NACKA SWEDEN +46 070 545 50 38 [EMAIL PROTECTED] -----Ursprungligt meddelande----- Från: [email protected] [mailto:[EMAIL PROTECTED] För John Docherty Skickat: den 18 mars 2008 11:05 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Unique Values I was wondering if there is a quick way of determining if all rows in a selection have a distinct value, the column in question being a text field. Any suggestions (or the obvious answer which I cannot think of), would be much appreciated. Thank you. Regards, John Docherty
