Just to give you a little more information on the data and the odd
results from
doing the 'Less Than comparison' in PICK:
1) in that field in the database there are 18,169 negative values,
ranging from
-0.000100 to -24661.203100
2) I tried doing the selection based on different numbers in the
stage "pick w2 <= /x/ ",
where 'x' and the number of records extracted are in the table below:
X Records Comments
0 18,169 Correct and expected
-1 18,006 Incorrect - there are 6133
-10 18,155 The number is going up and selected more?
The actual number of records is 689
-100 18,168 So we got all of the negatives but
one? Actual
record count should be 76.
-1000 18169 Pulled them all. Actual count is 19.
-10000 18169 Actual count is 5.
