View Single Post
  #1  
Old May 25th, 2010, 09:36 PM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
 
Posts: 5,361
Default How to find text that is surrounded by a wild card, specificly an

Dan wrote:

I am looking for a way to query for the following:

*T*

The problem is the T is surrounded by an * which is a wild card. It pulls
all the records with a T included. But I literally want to find all records
with *T* (with the * on both sides of the T). I found out you can find all
records with an * by running a query for the following:

*[*]* (which is cool. But I want to find an exact match of *T* )


Like "[*]T[*]"

--
Marsh
MVP [MS Access]