SQL Report Wildcard

Dan S

February 07, 2019 20:13

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

2 comments

Dakota Clark
February 07, 2019 23:40

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

0
Dan S
February 08, 2019 16:58

Perfect! Thanks!

0

Please sign in to leave a comment.

New post