Selecting records that start with two asterisks and a spacebar

  • Thread starter Thread starter Morris
  • Start date Start date
M

Morris

Hi!

I'm trying to show only the text fields which start with "** " - how
should I 'escape' the asterisks and the spacebar?
 
Morris said:
Hi!

I'm trying to show only the text fields which start with "** " - how
should I 'escape' the asterisks and the spacebar?
Click to expand...

yup, LIKE "[*][*] *" works :)

cheers
 
Add a field in the design grid like this --
JustChecking: Left([YourField],3)
Use this as criteria --
"** "
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter asterisks from a field 2
Searching for asterisks within fields (not using as a wild card) 4
Search for Multiple * Literals 1
extract text between asterisks 1
Spacebar now acts like Backspace 8
Filter also is a wildcard 4
Asterisk next to a Sendkeys function in a macro 0
Change query criteria by form with wildcards 6

Back
Top