Filter Sales Order Document for less than 10000

bbender

With SQL version, one of our customers wants to filter on Documents < 9999.
When filtering is applied, it gives Documents higher (like 10000).
I tried 0000..9999 and this did the same thing.
How can you set this filter to get any documents less than actually ten thousand.

mohana_cse06

Is it Document No.?

Where did you put filter in report or form?

kine

Do notforget that SQL is sorting the data by ASCII order (or by order gven by the collation). The document no. is not number, it is text. Thus 100<2 etc... and if you are not using no. series as proposed (same length, beginning with character), you can have this problem...

Sog

Which means the question starts to differ: Now it's how to filter documents with only 4 characters as doc. no.= '????'
And you'll have all the documents less then 10000