Simple query to return records matching a word in a text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I design a query to return records for example, a specific town or
state, where the complete address information is contained in a text string.

123 Airport Ave, Spokane, WA. (example) - So I want all the records with
spokane in a query result.
Mike
(e-mail address removed)
Thanks
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the LIKE operator. E.g. (find WA states)

SELECT ...
FROM ...
WHERE Address Like "* WA*"

Note the wildcard characters before & after the "search-for" string.
Read the Access Help articles on wildcard characters - probably in the
Help article on "LIKE."

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

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

iQA/AwUBQd2NwYechKqOuFEgEQLMGACgot39/5MQqhG8C+VBs2QV/U/lH1EAoL1T
fPUZhAcABJ8d09eN7hbQOK8H
=LtiX
-----END PGP SIGNATURE-----
 
Back
Top