HELP!! Query "LIKE" operative use!

[FredPeters]

I am using a form to input a string to send to the query to produce names that have the queried string inside. eg Input pet to get Peters, Petrie Gepetto Trumpet etc. I'm going crazy trying to get the syntax using both % and * wildcards. The Access and VBA help examples aren't producing results. I can send the whole name and get results when the query is set for complete, but no partials.

HELP
Fred

 

[kevinclark]

Access uses * as the wild card
Might also want to make sure you are forcing everything to UpperCase (or Lower) when comparing - Just in case

Dim strName as String
Dim strSQL as String

strName = UCase(UserForm1.TextBox1.Text)

strSQL = "Select * from YourTable Where UCase(fldName) Like *" & strName & "*"


Maybe attach the SQL you are using if this does not work

 

[kevinclark]

Oops sorry - I think there should be single quotes in that previous SQL statement as well

example:
strSQL = "Select * from YourTable Where UCase(fldName) Like '*" & strName & "*'"