I need to change the itemcode and descriptions to all caps and i need to have all items with a a barcode of 3 of 9 extended.
thanks
I need to change the itemcode and descriptions to all caps and i need to have all items with a a barcode of 3 of 9 extended.
thanks
UPDATE Item SET ItemLookupCode = UPPER(ItemLookupCode), Description = UPPER(Description), LastUpdated = GETDATE()
For barcode 3 of 9 extended ..
UPDATE Item SET BarcodeFormat Replace value with correct value :)
sorry cod
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.