How to use "like" in following case

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

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

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]
 
Back
Top