Hi all :) I'd like to make a little vb.net 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 :)

7 Years
Discussion Span
Last Post by NorthDakota
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.