like comparison

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

Is their a method to replicate the like comparison used in
a table by selecting the match any part of field option?
In findfirst . Replacing the equals with like?

rcdAmendPC.FindFirst "company Like '" & Sname & "'"
 
rcdAmendPC.FindFirst "company Like '*" & Sname & "*'"

In some cases (such as when you're using ADO), you'll need to use % as the
wildcard instead of *
 
Thanks
Jenny
-----Original Message-----
rcdAmendPC.FindFirst "company Like '*" & Sname & "*'"

In some cases (such as when you're using ADO), you'll need to use % as the
wildcard instead of *

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)





.
Click to expand...
 
Back
Top