Answered

Excel SQL WHERE CONTAINS

(0) Share

Report

Posted on by lowdmt

Hi,

I'm struggling with the syntax for a SQL query on Excel using PAD. I want to return rows WHERE [COLUMN] CONTAINS the letters 'Civ'. This could be anywhere in the string. If I use %Civ% then PAD looks for a variable called Civ rather than using the % characters as wild cards.

I have tried creating a variable called Civ with Civ set as the variable value but that doesn't work.

How do you achieve this in PAD?

Any help appreciated

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

kinuasa 801 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
You need to be escaped using another percentage character [%%] as follows.
SELECT * FROM [Sheet1$] WHERE F1 LIKE '%%Civ%%'

Regards,
kinuasa

Was this reply helpful? Yes No
lowdmt 98 on at

Like
a
(0)

Report
Copy link

Link copied!

@kinuasa that's exactly what I was looking for. The escape character.

Thanks 👍

Was this reply helpful? Yes No
lowdmt 98 on at

Like
a
(0)

Report
Copy link

Link copied!

@kinuasa

How do I search for 2 LIKE queries...

%%Civ%% OR %%Cv%%

LIKE (%%Civ%%,%%Cv%%)

??

Was this reply helpful? Yes No
kinuasa 801 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
You can specify multiple conditions in the LIKE operator as shown below:
SELECT * FROM [Sheet1$] WHERE F1 LIKE '%%Civ%%' OR F1 LIKE '%%Cv%%'

Was this reply helpful? Yes No