Using Like %

D

DHWI

I'm new to Access 2003 is there something that changed from 2000? I have
this data
AB
ABC
DD
DER
And want to pull the records back that contain B, so I would use LIKE '%B%'.
Correct? Only this does not work. Any ideas?
Thanks much!
 
A

Alex White MCDBA MCSE

This depends on if you are accessing MDB data or SQL data

your example is for SQL for access you need * instead of %
 
R

Rick Brandt

DHWI said:
I'm new to Access 2003 is there something that changed from 2000? I
have this data
AB
ABC
DD
DER
And want to pull the records back that contain B, so I would use LIKE
'%B%'. Correct? Only this does not work. Any ideas?
Thanks much!
Click to expand...

Jet tables or a server back end? DAO or ADO or a query?

With Jet/DAO/query the wild card is *

With ADO/most server back ends the wild card is %
 
Top