query help please

(0) Share

Report

Posted on by Craig Wood

785

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. Craig

*This post is locked for comments

All responses (2)

Answers (0)

Craig Wood 785 on at

Like (0)

Report

Re: Re: query help please

Thanks for the reply Convoluted. I knew I would be able to count on you if no one else responded. It's also a good example of how much faster the response time is on the NG versus this forum. It's just a much better setup since you can get all the posts right next to your email, it's much more likely the people you need to see your question will actually see it in a timely manner. With the forum there's an extra step involved. That doesn't seem like much, but in our busy daily lives it can make all the difference in whether or not the help comes when needed. Craig
Community Member Microsoft Employee on at

Like (0)

Report

Re: query help please

Hi Craig - saw you got a solution on the Corn Flakes Newsgroup ("The Original and Best").

Good example of how solutions are quick to come when the end user knows and communicates what it is they are trying to accomplish, or what business issue they are looking to solve.