Selecting records that start with two asterisks and a spacebar

M

Morris

Hi!

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

Morris

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
 
K

KARL DEWEY

Add a field in the design grid like this --
JustChecking: Left([YourField],3)
Use this as criteria --
"** "
 
Top