1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Answered

SQL Report Wildcard

Avatar
Dan S

What is the wildcard for SQL reports? I've tried several things including % and * without success. When i run this I get APP1 results but that's it.

where (Applications.Name = 'APP1' OR Applications.Name = '%APP2%') AND

0

Comments

2 comments
Date Votes
  • Avatar
    Dakota Clark

    You'd have to use OR Applications.Name LIKE '%APP2%' for the wildcard to be evaluated.

    0
  • Avatar
    Dan S

    Perfect! Thanks!

    0