Addis accession numbers
Addis does not use accession_number_part2
(similar to #1 (closed)) and there is no string prefix at all, just numbers.
update accession set
accession_number_part2=cast(accession_number_part1 as bigint),
accession_number_part1=''
;
update inventory set
inventory_number_part2=cast(inventory_number_part1 as bigint),
inventory_number_part1=''
where
form_type_code= '**'
;
I need to check if GG-CE Web allows for a blank prefix (number_part1
).