item notes field

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!

Reply to
Mickie
Loading thread data ...

Hi Mickie - backup first and try after hours if possible

UPDATE item SET notes = 'clearance' where subdescription2 like '%clearance%'

the percent sign is your wildcard for the subdescripti> I need to add a note to all items that meet a certain criteria.

Reply to
convoluted

That did it!!!

Thanks so much!

"c> Hi Mickie - backup first and try after hours if possible

Reply to
Mickie

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.