Marc, Are you trying to create one row in your new table for each each day with the varchar column containing 2, or more, rows/values from the original table?
If so, you probably need to insert the first row for each day first and then update the varchar column with the additional values: INSERT INTO newtable SELECT ... FROM oldtable WHERE DAY = [date] AND rownumber = 1 SELECT varchar INTO newvalue FROM oldtable WHERE DAY = [date] AND rownumber = 2 -- repeat for row 3, etc. UPDATE newtable SET varchar = (varchar & .newvalue) WHERE DAY = [date] Of course, I may have totally misunderstood your requirement and others may have better ways... Regards, Alastair. ----- Original Message ----- From: MDRD To: RBASE-L Mailing List Sent: Wednesday, June 24, 2009 11:14 PM Subject: [RBASE-L] - Small Brain twister ... at least for me Hi I have a table with custnum, TrDate, Notefield, Vernumber. There may be more that 1 row per day but the Vernumber is an autonumber field and should have a bigger number for the second note for the day. I want to Insert the rows into a new Table using a Varchar field. I want to have a PK on custnum and the date in the new table. This is easy but I want to add the second row for the day to the bottom of the Varchar field for the days with 2 rows. This is where my brain starts to twist. I can think of clunky ways of doing this but I am sure there are better ways than what I an thinking of? Is there a simple way to do this or do I just clunk along? Thanks Marc ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.90/2198 - Release Date: 06/23/09 17:54:00
