cannot use * in ado record sets

I have a program that looks up data in an access database using an ado recordset in visual studio 2005. my problem is that i wanted to be able to enter something into a text box and select only records that CONTAIN what ever is in the text box. i've tried the following:

"select * from myQuery where (field like *'" & textBox.text & "'*);"

which works with an access query but when i've used the exact same statement in a recordset.open command it doesn't find any records. does anyone know why this is happening or another way of searching records?

Been ages since I've messed around with access, but shouldn't the ' be on the other side of the *?

Like this:

Code:

---

"select * from myQuery where (field like '*" & textBox.text & "*');"

---

johntheface,

In addition to Alsvha's comment, I thought ADO's wildcard character was %, not *.

Kerry Moorman

Quote:

---

Originally Posted by kmoorman

johntheface,

In addition to Alsvha's comment, I thought ADO's wildcard character was %, not *.

Kerry Moorman

---

For MS-Access databases % sign does not work. You will have to use * as shown in Post # 2.

this is correct:

Code:

---

"select * from myQuery where field like '" & textBox.text & "*'"

---

no * before the like field, but afterwords. For phone numbers, I've found that we had to use % before. YMMV

Quote:

---

Originally Posted by Shuja Ali

For MS-Access databases % sign does not work. You will have to use * as shown in Post # 2.

---

Not sure I understand or agree ( although I'm not a boffin on databases )
In a recent project, using MS Access, I had to use the % indicating the remaining characters.

I did this :

Code:

---

      PlaySearch = "SELECT * FROM " & pclListPT.PCLRetStr '& " WHERE " & _
            PlayFieldStr & " LIKE '" & abPConditions.Text & "%' "

---

When I entered a value such as Met in the abPConditions TextBox, it returned all values starting with Met. So, If I used the Artist field ( pclListPT.PCLRetStr ) , it returns me all Metallica records.

It works for me

Quote:

---

Originally Posted by HanneSThEGreaT

Not sure I understand or agree ( although I'm not a boffin on databases )
In a recent project, using MS Access, I had to use the % indicating the remaining characters.

---

I stand corrected. :)

I have not touched MS-Access since past 4 years now. I remember using * as a wild card, but that might have changed now.:o

As I recall, you use % in ADO(.NET) queroes, but * within Access (as a front end to Jet) for wildcard

If you prepare a query in MS Access you must use * char..
but if you connect database with Ado, you must use % char...

I have used % char in many projects..

thanks guys, it's %