Why Filter do not function?

Belias

I noted that filters like <>A* does not function in navision. the '*' character is read as it is and not for a part of string (as in filters like A* is done). in Nav 4.0 there isn' this problem.

is there a work around about that?

Waldo

Not really true.
I tested in 4.0, and a filter <>T* gave me records starting with "T" as well.

As a workaround you could be filtering in code ... using temp tables ... . Only thing about that is that it would only be for that one field that you program it for ... .

Sorry ...

Belias

i had already tried to filter using code, but it doesn't work.(in nav4.0 the filter works!)

kine

1) I posted somewhere about this problem before, but who will find it in the heap... :-)

2) From On-Line help about entering filter criteria:

<>
Not equal to
<>0
All numbers except 0

The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any texts that start with A.

It means, this is working just on MS SQL server and not in native DB.