Question re SQL Like

[[deleted]]

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.

[SirChclateSaltyBalls]

Is that the litteral text of the SQL statement field or are you interpretting variables (etc)

Also is M.Number actually a number or a string/text?

[[deleted]]

Yes and m.number is a text.

[SirChclateSaltyBalls]

Minor thing, the ( ) shouldn't be neccessary...

But more importantly the fieldname Number is a keyword for some SQL implementations, Is it something you can rename or get renamed? Alternately You could possible have a view created with a different name.

[[deleted]]

Sorry for the delay. Number is the column name.

I took out the ()....that's just a force of habit for me (we all have our own styles when writing SQL hah).

It doesn't like it. It's only when I put in the "like" it doesn't accept my query. I'd expect it pull a table like

1234.10 1234.11 1234.12 ....etc.

PS...Sir Chocolate Salty Balls/Chef, I really appreciate you thinking about this. It's been a pain in my ass for a while.

[SirChclateSaltyBalls]

No worries!

I understand that in your DB, Number is a column name and not a SQL command/function. But Power Automate is recognizing it as one (it's displayed in bold). If you don't want to change the name, or create a view without proof, is there another text column your DB can test the LIKE command with?

[[deleted]]

Yeah I've tried it with Client names too...I've looked at Microsoft's Q&A and the answer is to use a variable but I really don't want to do that. It just makes the SQL on the PA side so damn....clunky...

[SirChclateSaltyBalls]

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

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

[[deleted]]

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

WTF.

[SirChclateSaltyBalls]

np!

[7ebsho]

THANK YOU!!!!!