Filtering operator for NOT EQUAL

RachelSoon

Hi There,
Anyone know how to do filtering for NOT EQUAL at the report filtering?

say, i would like to print all customer except the customer code start with M. What is the syntax to exclude the customer code start with 'M'.?

I put the filtering as <>M, but the records still show those customer code start with M.

Appreciate if anyone can help me.... thanks

Regards
Rachel

kine

<>M*

RachelSoon

<>M* does not work too.

kine

OK, it seems that in Navision SQL Option is working but on Native (Navision0 DB not...

RachelSoon

Hi Kine,
hhhmmm.. the filtering at the SQL does not work too.

I;ve tried both SQL and navision database.

kine

I used finsql.exe from 3.70B....(some bugs related to security filters are corrected etc.) but from context help:

<>
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.

Oh, OK, I found that this is correct only for NA3.70 not in NA3.60... sorry.

RachelSoon

:roll:

meaning the <> does not work on 3.60....

kine

No, only <>M* does not work... <>M is working, but code must be exactly equal to M

Savatage

i slightly remember a similar post way way back maybe last year. I'll try & do a search later. unless someone else remebers this also?

wonmo

SETFILTER("Customer Code", '<> %1', 'M*');

RobertMo

..M|N..
I checked it on 3.60 native...

BTW. To be exact this example will include only one string that begins with M, that is 'M'. If you want to avoid this use ..LZZZZ|N..

Savatage

Awsome!

RobertMo

and if LZZZZ is not enough check fin.stx for //sorttable.
In Slovenian { is very near the end so ..L{|N.. will for sure do the job.