Lin You could project a new table from sourcetable containing the 2 letter codes and then do an insert.
PROJECT NewTableName FROM sourcetable USI LetterCodeColumn WHERE COUNT = 0 INSERT INTO NewTableName (LetterCodeColumn) SELECT DISTINCT(LetterCodeColumn) + FROM sourcetable You could also do this (this could take some time if the table has a lot of rows) PROJECT NewTableName FROM sourcetable USI ALL DELETE DUP FROM NewTableName USI LetterCodeColumn Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Sunday, January 20, 2008 9:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Load a table from values in another One of the really nice things about redesigning something after 15 years is that it gives me an oppurtunity to correct problems that have bugged me for a long time! And, this is another one. I have a table with a column that contains 2 letter codes. There can be many rows that will contain the same code. I'd like to load another table with 1 instance of each of the codes that appear in the first table. This is a one shot deal; just to get a new table up and running. Is there a function that would help me with this? Seems to me that I remember something about one. thanks, Lin
