Re: Select query: retrieve specific terms only when followed by a spac
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 03:52:59 -0700
On Thu, 25 Aug 2005 03:37:03 -0700, Andrea Mann wrote:
> Dear all,
>
> I am trying to create a select query that will retrieve my specific text
> terms only when they are followed by a space.
>
> For example, one of my text search terms is "*hepatitis C*".
> I want to retrieve "hepatitis C Cirrhosis" but not "hepatitis Cirrhosis".
>
> Thank you in advance for your help!
>
> Best,
>
> Andrea
Place a space before the wildcard.
Like "Hepititus C *"
Actually if you wish the user to enter the criteria, use a parameter
prompt:
Like [Search For] & " *"
The above will find the phrase if it is at the beginning of the field.
To fine the phrase anywhere in the field use:
Like "*" & [Search For] & " *"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
- References:
- Select query: retrieve specific terms only when followed by a spac
- From: Andrea Mann
- Select query: retrieve specific terms only when followed by a spac
- Prev by Date: Null values
- Next by Date: Re: help with correct syntax
- Previous by thread: Select query: retrieve specific terms only when followed by a spac
- Next by thread: Null values
- Index(es):
Relevant Pages
|
