Start New Discussion within our Software Development Community

Hi all :) I'd like to make a little program that executes searches on a msaccess database. I use a textbox to get the value to search and than i'd like to search all the values that has the textbox value in the middle. So, the queries should look like this:

SELECT Rec1, Rec2, Rec3 FROM Table1 WHERE Rec1 LIKE "*" & txtTextBox.Text & "*"

My problem is that i don't know how to pass the "*" character to my query, if I build a string that i pass to OleDbCommand(), the query returns nothing

*PS I use OleDbCommand to pass queries.

*PS2: eventually, sorry for my bad english :)

This question has already been answered. Start a new discussion instead.