Ibadan Inventory barcode
The inventory barcode in Ibadan has 8 digits, with zeros (0) on to the right side as padding, but the current data in the barcode field doesn't have padding.
in this example, the barcode must be
to fix the problem, please, execute this script:
barcode = right('00000000' + rtrim(ltrim(barcode)),8)
where barcode is not null