help with access query

Question

hi

i have table MyTbl that has Barcode field.

i need to update all record's that Barcode < 13 with 0 (like pad left)

 1234567890123 = 1234567890123

 12345678      = 0000012345678

thank's in advance

Answer 1

update MyTbl
  set barcode = right$("0000000000000" & barcode, 13)
where len(barcode) < 13