Prev: 2 quesions about query
Next: arr records except last
From: Silvio on 23 Mar 2010 12:19
Jerry, it appears to work with: Not Like 'B[_]*'

"Jerry Whittle" wrote:

> Are you linked to an Oracle database? The % wildcard implies so.
>
> For Access the following will work:
>
> Not Like "B_*"
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Silvio" wrote:
>
> > Hello folks, I am trying to exclude record from a query that start with a
> > letter followed by the underscore and other letters. Example:
> >
> > B_test
> > B_test2
> > B_Hello
> > B_Mach
> > B_yellow
> > BA
> > BT
> >
> > In this example, I need to exclude anything that starts with B_
> >
> > My understanding is to use the NOT Like function in that colum criteria such
> > as:
> >
> > Like 'B[_]%'
> >
> > However, it does not do anything (I still get all the records). I know that
> > underscore is in SQL is not being considered laterally. So how do I handle
> > this?
> >
> > Thank you,
> > Silvio
First  |  Prev  | 
Pages: 1 2
Prev: 2 quesions about query
Next: arr records except last