Skip to main content

Notifications

Microsoft Dynamics RMS forum

query help please

Posted on by 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

  • Craig Wood Profile Picture
    Craig Wood 785 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,888 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,247 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans