Re: query filter not like
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2008 11:51:57 -0600
On Tue, 11 Mar 2008 06:52:02 -0700, Murata-PS
<Murata-PS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have a field that contains 6 digits, then an astrik, then 3 digits, then an
astrik , then possible 2 digits, then an astrik and 1 digit. I need to
filter for all but the records that contain the last astrick and 1 digit. I
have tried "Not Like "######" & "*" & "###" & "*" & "#" & "*" & "#" - but no
luck - can anyone help ?
The trouble is that an asterisk is itself a wildcard, so searching for it will
treat it as a wildcard, matching any string of characters or nothing at all.
The getaround is to put it in square brackets so that it will be treated as a
literal asterisk, not a wildcard:
NOT LIKE "######[*]###[*]#"
will find all records except those with five digits, a literal asterisk, three
digits, a literal asterisk, and one digit.
--
John W. Vinson [MVP]
.
- References:
- query filter not like
- From: Murata-PS
- query filter not like
- Prev by Date: how to get percentages?
- Next by Date: Re: Dates for the whole month
- Previous by thread: Re: query filter not like
- Next by thread: Dates for the whole month
- Index(es):
Relevant Pages
|
