Filter by containing string not = string, ADO

[Paul Sansom]

Hi I have a sub that is my query filter. It current filters bra on "=" to cell input. I cannot work out the syntax for a "containing" filter e.g contains bra.
I have tried a simple subtituion of = for contains but it does not filter correctly......
'myADO.RunQuery "Select [Photo Number], [Branch Ref], Comments, Place, [Viewing Order], Date, [Source Other Names], [Source Last Name] From [Photos$]" _
& " Where [Branch Ref] contains '" & bra & "'", shResults

Any guidance always gratefully accepted.. Paul

Code shown works well as = string!!!!

Sub byBranchRef()
'   Filter by branch ref
    Dim myADO As New clsADO
    myADO.Connect ThisWorkbook.FullName
    
    bra = Output.Range("d5")
    
    myADO.RunQuery "Select [Photo Number], [Branch Ref], Comments, Place, [Viewing Order], Date, [Source Other Names], [Source Last Name] From [Photos$]" _
        & [B]" Where [Branch Ref] = '" & bra & "'"[/B], shResults
    
End Sub

 

[Joe4]

Try this:

Where [Branch Ref] Like "'*" & bra & "*'"

 

[Paul Sansom]

Try this:

Where [Branch Ref] Like "'*" & bra & "*'"

No "Argument not optional", and I tried every combination of * inside or outside the quotes without success. The Like is accepted but is the same as = if no wildcard *

 

[Joe4]

OK, I was hoping that ADO syntax would be similar to SQL syntax, but it appears that might not always be the case.
I found this article here, and it seems to imply that ADO uses "%" as wildcards: Wildcard for SQL LIKE Using ADO

So maybe try:

Where [Branch Ref] Like "'%" & bra & "%'"