Hi
i am converting some data in our POS System which currently uses 13
digits for UPC codes (eg 0000000001234) however our Barcode software
requires the UPC to be 12 digits (000000001234) I would like to run a
querie that can take all of the current UPC's in our system and place
them in a new table with the extra zero removed from the front of the
upc. How can I do this the easiest? My tables are as follows
Products (tablename)
UPC
Barcode (tablename)
UPC
As mentioned above I just need to trim the furthest left 0 from the
results.
Thanks
Shannon