Wildcard SQL query

[simeybt]

All,
A quick one I know I am stupid, but I have done access for a while do I search for a part of a string in field. Here is what I am trying to do but it is not working

SELECT *
FROM Employee
WHERE ((([Employee]![Grade])="*agency*"));

Simon

 

[tvett]

replace the "=" with " like " (without the quotes)

 

[rdodge]

The following is the table for wildcards:

[tt]
Access SQL
Any number of characters * % (Percent)
One Character ? _ (Underscore)

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.

 

[rdodge]

One other thing, SQL tends to want to use the LIKE operator instead for pattern matching.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.