Question Cannot use 'Like' condition in dataset designer with MySql db

[gate7cy]

I am using visual studio 2008 and I am trying to create some queries in my designer to use in my form. The query I am trying to use is:

SELECT Address, Balance, Block, Code, CustName, CustomerID, Email, Fax, FlatNum, HouseNum, LastEditBy, Mobile, Nick, Other, OtherTel, PostCode, Street, Surname, Telephone, Town, UserID, Webpage 
FROM customer 
WHERE (Surname LIKE @Param2)

When I run this and whatever I enter for the parameter value I get zero results. When I dropped the parameter and enter the value/letter with the wildcard directly in the where clause I get the correct results.

The issue is that I have tried all different versions of the wildcard and how to use it but the only thing I get is syntax errors. I am using MySql V.5.0.45. The designer will not let me use a wildcard with the query. What is the correct syntax to use wildcard/parameter with VB.net and MySql?

 

[kulrom]

that starts with:

WHERE (Surname LIKE @Param2 + '%')

or that contains:

WHERE (Surname LIKE '%' + @Param2 + '%')

 

[gate7cy]

That starts with that.

 

[kulrom]

It worked for you?

 

[gate7cy]

What worked for me? I do not understand your question. thanks for the efforts