How to use the Like operator in Parametric queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Siamak - 13 May 2005 15:54 GMT

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

Reply to this Message

Ofer - 13 May 2005 16:02 GMT

Try that

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

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

Reply to this Message

fredg - 13 May 2005 16:09 GMT

> 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] & "*"

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message