Unanswered

Parsing values from PDA to Teradata SQL

(0) Share

Report

Posted on by Steve112

Good day all

I am trying to pass a variable, lets call it %UserInput% in Power Desktop Automate
to a Teradata SQL statement that gets executed as part of the flow.
In my SQL code I have a LIKE function ie: Where Name LIKE ‘%lookup-value-goes-here%’
How would I parse the PDA variable into the LIKE statement, as the LIKE statement requires the % characters in front and after the ‘name-goes-here’
Any suggestions would be appreciated. Thanks

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

although link below is not using variable but to escape % either %% is used or \%.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Issue-with-like-opetator-and-special-char/m-p/743562#M493
Steve112 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you, will check that doco
dchen 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried both %% and \%

Both of them are not working

Any idea how to have the SQL statement to include wildcard % in for the 'like' or 'not like'

e,.g.
like '%text%'