I have a field 'called patno_samno' in an SQL 7 table called 'anal_06' which has data in the following format -
I want to put the first part (218469) into another field called 'patno1' and the second part (001) into a field called 'samno1'. There are thousands of these entries. The first part (the patno) all have 6 characters and the second (the samno) all have 3 characters and both are seperated by a dash in the 'patno_samno' field.
How do I copy the required data to seperate fields please?