Developer Forum

I am using Order Entry Database from Access.

I want to create a query that OMITS any names that start with Sky. How do I
create the expression.

Thank you

In the criteria of your name field, put:
Not Like "Sky*"

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

SELECT <column list>
FROM <table name>
WHERE last_name NOT LIKE "Sky*"

If you've set up the DB to use ANSI92 syntax you'll have to use the %
character as the wildcard character instead of the *.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBRASwyIechKqOuFEgEQIR0gCgtewfxpk7J50CIOIP3J2hmgJl1VYAoMWp
kWbLKTQKpIbPVlIkr9aiLYSD
=CElm
-----END PGP SIGNATURE-----

Not Like "Sky*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks to all. It works.




I