How to use "like" in following case

[Guest]

Data in the field "class4" are
abc
bfg
mnt

I need to find out any data with "b" in any position.
I tried
WHERE ((([main].class4) Like '%b%'))
But it returned nothing in the query.

 

[Duane Hookom]

Access uses "*" rather than "%".

 

[John Vinson]

Data in the field "class4" are
abc
bfg
mnt

I need to find out any data with "b" in any position.
I tried
WHERE ((([main].class4) Like '%b%'))
But it returned nothing in the query.

If this is a JET (mdb or mde) Access database, the wildcard character
is * rather than %. Try

WHERE [Main].[Class4] LIKE "*b*"

John W. Vinson[MVP]