Important Notice: On February 29th, this community will be put into read-only mode. All existing posts will remain but customers will be 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

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
  • You'd have to use OR Applications.Name LIKE '%APP2%' for the wildcard to be evaluated.

    0
  • Perfect! Thanks!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post