I just have a jet ado conn opned.
my db is access
my table is named Mytable
Into field CODE have a value similar:

0500-1
6875-45
...

How to update, with a sql query to format the right item from "-" in #000000 for all value in column field.
and have a result similar

0500-000001
6875-000045
...