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*'
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
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 ´
Example:
SELECT * FROM device where ( model like %'\"%Desktop%\"'% or model like %'\"%Laptop%\"'% or model like %'\"%Workstation%\"'% ) and status ="Completed"