> > I would like to add "omit <> 'yes' " to the WHERE clause. When I
> > do this, the
> > query returns 0 records (unmodified, it returns 25 records).
> AND NOT omit = 'yes'
In addition to Kevin's comments, some flavors of SQL (especially SQL Server)
treat NULL differently - so "NOT omit='Yes'" w
John,
You should be able to say:
AND NOT omit = 'yes'
That's assuming that omit is a text field and not a boolean (yes/no)
field. If its boolean you could just say:
AND omit = false
hth,
Kevin
At 01:33 PM 8/11/00 -0700, you wrote:
>Hi all
>
>Here the query I'm trying to edit:
>
>
> SELEC
2 matches
Mail list logo