What does "Alike" in the filter criteria mean?

G

Guest

When I type a filter in the query design for 5154* it returns Alike 5154 and
does not work although 5154 exists in my database. If I type Like "5154" it
returns Alike 5154. How do I get this database to filter for anything like
5154? Also, what does Alike mean in the criteria field? I can't find it on
any help site.
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

ALike = ANSI Like. Works the same as Like, but use the ANSI wildcard
characters (% = * and _ = ?).

Try the ANSI "any character" wildcard % :

Like "5154%"

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9AKL4echKqOuFEgEQK3gwCeP4Xq0Ttxg9hnNSjV3r/TBw8pVVUAn0Er
+kEkpFPQiApAo9d+7U2golKe
=WGQX
-----END PGP SIGNATURE-----
 

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

Top