Sir,
Please guide me to filter out the below bound information on a Table.
Suppose A table is build a field(pk) called Value (Data type Code 20).
Table contains the record for the field Value starting from 1 to 9999999.
Now I want to filter the Table Data starting range from 9710101 to 9710399 and 9640601.
Currently I have handled the scenario with the help of EVALUATE function.
Thank you.
Now or Never
0
Comments
Hi
From a SQL prospective a "Code" Field type is a standard nvarchar like a "Text" field type.
So if you put an integer to a text field you will see a sort like:
1
10
11
2
3
35
36
37
9
99
If you place a setrange(mytextfield, '2', '5') you will receive "2","3","35","36","37".
You must usa an appropriate field type like "Integer" or place some "0" before your number.
something like:
001
002
003
009
010
011
035
036
037
099
The alphabetic order will be similar to integer sequence.
Bye
Matteo
However, for that very specific example you present, the range-numbers have the same number of digits, so you can write your filter simply like this:
SETFILTER(Value,'9710101..9710399|9640601');
But note that it would not work if the from/to range values had different number of digits.
Microsoft - Dynamics NAV
Sir,
Above mentioned line force me to knock the expert door. [-o<