I imported the PLUs from a grocery store into RMS. Is there a way to append the 0 in front of all ItemLookupCode that have a length of 10 AND do not start with zero?
After I do that, how do I make sure HQ sync's those items with SO?
David
Adding a Leading edge Zero to PLUs
Nov 24, 2005
1 Replies
ALWAYS take a backup of your database BEFORE running any update, insert or delete query!
update item with (rowlock) set itemlookupcode = '0' + itemlookupcode, LastUpdated = GetDate() where len(itemlookupcode) AND itemlookupcode NOT LIKE '0%'
Then run a 250 worksheet for all recently changed items...
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required