I posted this on the forum, but thought I'd post it here too.
I need to add the words "dog food" to the extended description of every item in my "Dog Food" Department. If someone could please help with a SQL query so I wouldn't have to go into each item individually I sure would appreciate it. I just recently purchased a Star TSP100 Future print receipt printer, and it has the capability to print coupons at the end of the receipt depending on key words you specify that show up on the receipt. Using the extended description field to add keywords for the software to pick up on is the best and easiest way I could think of achieving this since not all dog foods have both dog and food in the description. Thanks in advance.