Using LIKE operator in an SQL statement not working. Please help.

[ToddMac]

Not sure what I am doing wrong and I am sure that it is a formatting error.


This works:

!lstSel.RowSource = "Select ag_auto, PID, AgreeNum, Contractor, LandOwner, Type FROM qryAgreeSel WHERE ag_del = 0 AND PID Like '*224*' Order by PID"

This doesn't:

!lstSel.RowSource = "Select ag_auto, PID, AgreeNum, Contractor, LandOwner, Type FROM qryAgreeSel WHERE ag_del = 0 AND PID Like '* & !txtPre & *' Order by PID"

Any help tweaking this is appreciated.



Thank you.

 

[theDBguy]

Hi Todd. Welcome to AWF!


Try it this way:

...WHERE ag_del = 0 AND PID Like '*[COLOR=red]"[/COLOR] & !txtPre & [COLOR=red]"[/COLOR]*' Order by PID"

 

[ToddMac]

Hi Todd. Welcome to AWF!


Try it this way:

...WHERE ag_del = 0 AND PID Like '*[COLOR=red]"[/COLOR] & !txtPre & [COLOR=red]"[/COLOR]*' Order by PID"

Sweet. I missed that.



Works perfectly.



Glad to be here!

 

[theDBguy]

Hi. Glad to hear you got it to work. Good luck with your project.