SQL Select LIKE

[doodle]

greetings. happy friday the 13th.

access 97, windows xp

Right now this populates my listbox with everything that has a part
name that exactly matches what is in the text box. i need it to return
anything with a part name that contains what is in the text box. i know
i need to use LIKE but i can't get the syntax right.

Private Sub Command9_Click()

Dim strsql
strsql = "Select * from tblLookupParts"
strsql = strsql & " WHERE PartName='" & Me.txtSearch & "'"
Me.lstTSUSA_Search.RowSource = strsql


End Sub

-doodle

 

[Brendan Reynolds]

" WHERE PartName LIKE '*" & Me.txtSearch & "*'"

 

[doodle]

thank you, brendan, now i can go home.


-doodle

 

[Brendan Reynolds]

I think that's one of the nicest responses I ever got to a newsgroup post.
It's so cool to think that someone was able to go home because of something
I did! Slán Abhaile! (Safe Home!)

 

[Dirk Goldgar]

Slán Abhaile! (Safe Home!)

How do you pronounce that, Brendan?

 

[Douglas J. Steele]

How do you pronounce that, Brendan?

According to http://www.tucsonirishcommunity.com/phrases.shtml, it's slawn
a-wall-ya (with stress on "wall")

Of course, I don't know whether it's appropriate to take pronunciation tips
from the American South West! <g>

 

[Brendan Reynolds]

That looks about right to me, Doug.

If you're really curious, and if you have RealPlayer installed, and after
you've fast-forwarded through two ads, you can hear the language spoken here
....

http://dynamic.rte.ie/quickaxs/nuacht-2006-10-13.smil