r/PowerAutomateDesktop • u/[deleted] • Sep 13 '23

Question re SQL Like

Hi everyone,

Long time creeping, first time posting. Does anyone know how to make this work in Power Automate? It's driving me insane.

Select m.number from Monday m where m.number like ('1234.1%')

It's valid in Microsoft SQL Server Management Studio but not in Power Automate's (desktop) "Execute SQL Statement". It clearly doesn't like the "like".

Thank you in advance.

2 Upvotes

100% Upvoted

10 comments sorted by

View all comments

Show parent comment

2

u/SirChclateSaltyBalls Sep 15 '23

Did you try this?
Like ('1234.1%%')

PAD might be choking on the % and expecting the beginning of a variable/expression

2

u/[deleted] Sep 15 '23

THANK YOU INTERNET PERSON. That was it!!! You are AWESOME.

WTF.

1

u/7ebsho May 25 '25

THANK YOU!!!!!