wilcard search in prompt window

  • Thread starter Thread starter Guest
  • Start date Start date
i would like to use a wildcard search in a prompt window for a query
Click to expand...

As criteria on the search field:

To find the search value anywhere in the field:
Like "*" & [Search for what?] & "*"

To find the search value only at the beginning of the field:
Like [Search for what?] & "*"

To find the search value only at the end of the field:
Like "*" & [Search for what?]
 
thank you very much!!

fredg said:
i would like to use a wildcard search in a prompt window for a query
Click to expand...

As criteria on the search field:

To find the search value anywhere in the field:
Like "*" & [Search for what?] & "*"

To find the search value only at the beginning of the field:
Like [Search for what?] & "*"

To find the search value only at the end of the field:
Like "*" & [Search for what?]
Click to expand...
 
Back
Top