Using Like %

[Guest]

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!

 

[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 %

 

[Lynn Trapp]

The wildcard in Access is "*".

LIKE "*B*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Rick B]

Like "*B*"

 

[Rick Brandt]

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!

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 %