Filter problem
Date: Wed, 12 Jan 2005 16:16:02 -0700
D7, Access 2000, ADO...
Filtering a table does not always accept the same syntax as a Where clause
in a query. I need to use the following filter, only negated:
Filter := 'CODICIL LIKE ' + QuotedStr('!%');
I tried NOT LIKE, I tried putting the NOT in front of whole expression in
parentheses, and I tried NOT (LIKE... with the appropriate closing
parenthesis, but in each case I get:
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
How do I do this?
Relevant Pages
- Re: Filter in the Join vs Filter in the Where
... And since your query and Bob's query both return the same result, it is not suprising that the optimizer generates the same plan. ... requires filtering to be applied to various columns from these various ... I will more often than not use the Join On to join the common ... and place any filters in the Where clause. ...
(microsoft.public.sqlserver.programming) - Filter in the Join vs Filter in the Where
... this is with SQL Server 2005 data. ... requires filtering to be applied to various columns from these various ... and place any filters in the Where clause. ... might write a query like this: ...
(microsoft.public.sqlserver.programming) - RE: Using an option group to display a subform
... you can add the WHERE clause to your query for filtering the records ... Did you encounter any problem when ...
(microsoft.public.access.forms) - Re: Date Range Totals for Logical Fields
... I'm sorry if I was not clear, but the test query ... based on how the filtering was working for you. ... it becomes a STRING (and so will sort/filter as ... "I put the where clause under the Group by Lead Date" ...
(microsoft.public.access.queries) - Re: case statement in where
... :> quez wrote: ... I would run the select with no where clause (maybe restrict it based on ... clause is filtering out that row. ... query precisely so I can easy check the ...
(comp.databases.oracle.server) |
|
