how does LIKE operator work?

[Eglute]

I want to write sql sentence with LIKE operator. I wrote this code:

Private Sub Command8_Click()
List1.Clear
Set db = OpenDatabase("the path of my database")
Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE '%Pet%';")
While Not rec.EOF
List1.AddItem rec!ID & "  " & rec!Vardas & "   " & rec!pavarde & "  " & rec!Data
rec.MoveNext
Wend
rec.Close
db.Close
End Sub

and my program does nothing. I don't undestand how does LIKE work?

[markmcgookin]

I want to write sql sentence with LIKE operator. I wrote this code:

Private Sub Command8_Click( )
List1.Clear
Set db = OpenDatabase("t he path of my database")
Set rec = db.OpenRecordse t("SELECT * From asmenu_info WHERE asmenu_info.pav arde LIKE '%Pet%';")
While Not rec.EOF
List1.AddItem rec!ID & " " & rec!Vardas & " " & rec!pavarde & " " & rec!Data
rec.MoveNext
Wend
rec.Close
db.Close
End Sub

and my program does nothing. I don't undestand how does LIKE work?

Hi,

I developed a VB app in the compact framework for a PDA and using SQL Sever CE and not MS access, but when I was doing something like this, I used this format:

I am assuming that you have assigned "Pet" as a string variable or something

i.e.

Dim Pet As String
Pet = "Dog"
 
etc...
 
Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE ' " & Pet & " ' ")
 

But I am not sure if that would be the same for an Access DB

[Eglute]

I didn't assign Pet as a variable because I think that it is only a string line I want to find in my database. Why need I to assign Pet as a variable? When I wrote this code in Access I wrote:

Set rec = db.OpenRecordse t("SELECT * From asmenu_info WHERE asmenu_info.pav arde LIKE "*Pet*"; ")

and the querry was good, but with visual basic it doesn't work. I don't understand why?

[Killer42]

I didn't assign Pet as a variable because I think that it is only a string line I want to find in my database. Why need I to assign Pet as a variable? When I wrote this code in Access I wrote:

Set rec = db.OpenRecordse t("SELECT * From asmenu_info WHERE asmenu_info.pav arde LIKE "*Pet*"; ")

and the querry was good, but with visual basic it doesn't work. I don't understand why?

Actually, I think you have the Like clause correct. It should work exactly the same from VB as when used directly in Access. However, I note that in your original post you have converted the asterisks to percent symbols. If you are still talking to an Access database, I believe you still need to use the asterisks.