Hi all I am try to add a numer to values that dont have a number
For example
from the data below A_CODE I would like to have AAA to AAA0 .AAA1,AAA3 etc for all values.
When the value is new then value + 0,then +1 and so on
AS you can see by the sample data there are different values.
Might have to use PL/SQL but could take some time


GROUP_Q_CODE GROUP_Q_DESC Q_CODE Q_DESC A_CODE A_DESC
1 OA Abnormality AAA ASSOCIATED ABNORMALITIES AAA YES
1 OA Abnormality AAA ASSOCIATED ABNORMALITIES AAA NO
1 OA Abnormality AAA ASSOCIATED ABNORMALITIES AAA NOT RECORDED
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES AAG YES
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES AAG NO
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES AAG NOT RECORDED
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN0 DUODENAL ATRESIA
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN1 DUDENAL STENOSIS
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN2 PYLORIC STENOSIS
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN3 GASTROESOPHAGEAL REFLUX
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN4 TRACHEO-BRONCIAL REMNANT
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN5 MALROTATION
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN6 MECKELS DIVERTICULUM
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN7 ANORECTAL ABNORMALITY
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN8 CLOACAL ANOMALY
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN9 OTHER
1 OA Abnormality GASABN GASTROINTESTINAL ABNORMALITIES GASABN10 NOT RECORDED
1 OA Abnormality AAH CONGENITAL HEART DISEASE AAH YES
1 OA Abnormality AAH CONGENITAL HEART DISEASE AAH NO
1 OA Abnormality AAH CONGENITAL HEART DISEASE AAH NOT RECORDED
1


gerard