I need to add a note to all items that meet a certain criteria.
I use Subdescription2 to designate the manufacturer's item number and also if the item is a clearance item (we put the word"clearance" there). This is so we can easily see this info on the first page of the item properties screen.
I want this info to print on the invoice also because that triggers a restricted returns policy.
The NOTES will print under the item on the invoice, so I would like to put the word "clearance" into the notes field for every item that has "clearance" in subdescription2 field.
Is there an easy way to do this?
My Nitrosell Product Attribute manager program won't mass-change this field because it is a MEMO type field. Will a SQL change query work on it?
If yes, can someone give me some hints on syntax?
INSERT INTO Item(notes) SELECT SubDescription2 FROM Item WHERE SubDescription2 LIKE @clearance YADA YADA YADA help?
Thanks!