| | |
|
|
|
How to do a Specific Search with " " |
|---|
| message from Miracle on 11 May 2004 |
Hey all... I have a database for a few thousand items with closely
related item names... I am trying to do a "find and replace" to rename
items in the database but here is the kicker.. when I do a search for
item *abc* the search is finding item *abcd*, *abcde* and so on. Is
there a way I can limit the search to find the exact name that I am
looking for? I thought maybe if I did a search and replace with " "
around the name that the " " would limit the search to abc, but it does
not seem to work. Any ideas?
Thanks in advance,
Chris
|
| Douglas J. Steele replied to Miracle on 12 May 2004 |
Are you looking for cases where abc is the complete "word", but it's in a
larger phrase, such as
He said purchasing abc would solve the problem.
You could try * abc * (i.e.: spaces between the asterisks and the word), but
that won't find cases where abc has punctuation after it:
He said purchasing abc, xyz and ijk would solve the problem.
The solution to the problem would be to purchase abc.
etc.
|
| John Vinson replied to Miracle on 12 May 2004 |
Yes; don't use LIKE and don't use wildcards.
Just put a criterion on the Item field of
abc
and it will find only those records where the exact and complete value
of the Item field is abc.
Note that an Update query may be a better tool than find and replace.
Make a backup of your database first just in case it gets messed up!
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: How to do a Specific Search with " " (Microsoft Access Database)
