Monday, March 12, 2012

Help with "like", "%" and "?" parameter on query

SELECT Conjunto
FROM Conjunto
WHERE (Conjunto LIKE % ? %)

I can't use like with % and a parameter doing a query on a tableadapter, can anybody help?

You cannot use param marker (?) as an embedded substring. You should do the following instead:

SELECT Conjunto
FROM Conjunto
WHERE (Conjunto LIKE ?)

and provide the pattern '%<substring value>%' for the param data.

Hope this helps.

No comments:

Post a Comment