John You could do something like this SELECT COUNT(*) TxtColumn FROM TableName + GROUP BY TxtColumn HAVING COUNT(*) > 1
Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Tuesday, March 18, 2008 6:05 AM To: RBASE-L Mailing List Subject: [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 --- RBASE-L =======================3D======================= D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D======================= D=
