How to use LIKE SQL with Power Automate Desktop

[Anonymous]

Hi everyone 

I am in need of help to query data using Like SQL Query Expression

so I have excel table with column named product_name

in product_name column we have D&D Asorted, D&D 56Pack and so on.

i want to pull this data using SQL query Like expression,

tried this SQL below but it cannot get the data

select product_name

from [Sheet1$]

Where product_name Like 'D[&]D*' 

[Sundeep_Malik]

Hey @Anonymous .

Check this out. 

Solved: Re: 'Like' for SQL query filtering - Power Platform Community (microsoft.com)

[Anonymous]

Thank you, i already look for that above.

when i set variable it give me syntax error.

1. set variable D&D is text not variable

i am not sure what i am doing wrong

[ThomasFonn]

I'm not very good at SQL so I may be wrong here...
It looks like you're using a quotation mark like this = ´
rather than an apostrophe = '
not sure if the SQL used in PAD supports the use of ´

[eeeeeeeeeeeeee2]

Example:

SELECT * FROM device where ( model like  %'\"%Desktop%\"'%  or model like   %'\"%Laptop%\"'%   or model like  %'\"%Workstation%\"'% ) and status ="Completed"

[martinaKolafova · Accepted solution]

Use LIKE '%%D&Dt%%' 

[Anthony_Luan051]

Many thanks friend, It too helpful and I have resolved my error.