syntax for Like statement
I am having trouble getting syntax right for my MySQL like statement.
I need the like statement to check against the request.querystring.
If I manually paste in the actual querystring name it works... but if I want to have dynamic data here it doesnt...
my current syntax:
WHERE (prodis LIKE '%'#Request("prodis")'%')
doesnt work. I tried so many othes ways!
I am using asp:SqlDataSource