expressions to omit info

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

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
 
jwrnana said:
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.
Click to expand...

-----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-----
 
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
Click to expand...

Not Like "Sky*"
 
Back
Top