I am trying to create a parameter query in a table adapter and use the LIKE statement to find data that contains certain text. The SQL command is below:

SELECT ID, UPLOADED, COPIES, MEDIA, COLOR, DUPLEX, ACCOUNT, GROUPNAME, DEVICENAME, FROM jobs_import
WHERE DEVICENAME LIKE ?

This Query only works if the value for the Parameter is exactly what is in the data field. I need to search for partial strings such as in Access where you use a wildcard: LIKE "*HP*" etc.

Anyone know how to do this?

Thanks

js

Try passing the text into a variable and using something like "...Like "'*" & varName & "*'"..."

I had the same problem and that worked for me.

Hope it works

Rob Carter