Friday 6 April 2018

How to trick PSQuery to use LIKE and UPPER

Client wants a PSOPRDEFN query that prompts user for OPRID...

Something that still works even if the user tYpEs LikE aN IdiOT or uses a wildcard character (%).


Ok, so your first instinct would be to create a new expression.

But then you realize, you can't use expressions if condition is LIKE.

Click Read More to see how to trick PSQuery to use LIKE and UPPER at the same time...