Filtering of Item records

sbhamidi

I'm trying to set a filter on the Item records as '<>D*' on the Item Card and Item List report. Neither works. What I want to look at is any items whose No. values do not start with the letter D.
I've tried this in Navision 3.60 and 3.70 A. Neither works.
Any suggestions? I'd appreciate some enlightenment.
TIAdvance.

Savatage

..D|E..

themave

POST DELETED, SORRY

Savatage

NO PROB O:)

sbhamidi

Savatage wrote:

..D|E..

WHY didn't I think of that? Thanks!

kriki

Savatage wrote:

..D|E..

Actually this is wrong, because if there is an item that has as "No." = 'D', it will be shown.
So the correct one would be :
'<D|E..'

It even gets (... or ) [... or :? ]:
'<>D*' works with SQL-DB, but NOT with Navision-DB

Savatage

the odds are sooooo slim that someone would actually name an item # just "D"

that's why i went with ..D|E.. :whistle:

I guess it's better to be %100 correct

kriki

Savatage wrote:

the odds are sooooo slim that someone would actually name an item # just "D"

that's why i went with ..D|E.. :whistle:

I guess it's better to be %100 correct

I thought it too when I wrote it, but... Never make assumptions. When you say : I don't program something, because the user will NEVER do that, you can be 100% sure he will. See Murphy's laws :!: