How to use the Like operator in Parametric queries?

[Guest]

How do I use the Like operator in parametric queries which prompt the user to
enter part of the value for a field?

 

[Guest]

Try that

SELECT Field1
FROM MyTable
WHERE Field1 Like ("*" & [Param] & "*")

 

[fredg]

How do I use the Like operator in parametric queries which prompt the user to
enter part of the value for a field?

To find records with the entered value anywhere in the field:
Like "*" & [Enter phrase] & "*"

To find records with the entered value only at the end of the field:
Like "*" & [Enter phrase]

To find records with the entered value only at the beginning of the
field:
Like [Enter phrase] & "*"