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
sql statement help
Apr 12, 2007
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required