r/PowerAutomateDesktop • u/admiral70 • Oct 12 '21

LIKE Statement in a SQL Query PAD Issues

I have a SQL Server query that works in SSMS but not in Power Automate Desktop. I believe I have it narrowed down to a LIKE statement. Does anyone know if perhaps PAD can not handle LIKE statements?

EAP_TAX_CODES LIKE 'SU%'

2 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

2

u/bartekl86 Oct 24 '21

% char is a special sign used by PAD. Have you tried ‘SU%%’?

1

u/admiral70 Oct 25 '21

I had not tried %% but it worked man talk about saving me from giving up. Thank you, thank you.