Simple Query

[Guest]

I would like to create a simple query that can a column of data for any row
that contains "com" in the cell. COM could be at the begining, middle, or end
of the values on the cell - i.e would like to use a wildcard *com*.

Is it possible ?

Thank you in advance.

 

[Lynn Trapp]

Select * from YourTable
Where YourField Like "*" & "com" & "*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html