Okay, that's actually more elegant than the workaround I was trying. Thanks Bill.
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Wednesday, March 04, 2009 11:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Select where not unique Damon, Just use standard SQL with GROUP BY and HAVING: SELECT invnum, COUNT (*) FROM tablename GROUP BY invnum HAVING COUNT (*) > 1 Bill On Wed, Mar 4, 2009 at 2:33 PM, Gray, Damon <[email protected]> wrote: I'm trying to find duplicate invoice numbers in a table and am looking for an "is not unique" or "where not unique" type function in 6.5++. Am I missing it, or does it just not exist? wwwww ( @ @ ) -------oOO---(_)---OOo------- Damon J. Gray Anvil Corporation Business Services (360) 937-0770 oooo0 0oooo ( ) ( ) ----------\ (----) /----------- \__) (__/
