Remember that select uses the data unconverted and unformatted (except for dates !) and You probably have a MD2 conversion here and if so the 0.0002 is stored as 0.02 that is larger than 0.01 ...
-- mats Marco Manyevere wrote: >Hi All, > >I typing the following commands in succession: > >SELECT F.ACCOUNT WITH EVAL "ABS(BALANCE)" GT 0.01 >15480 record(s) selected to SELECT list #0. > > >>>LIST F.ACCOUNT EVAL "ABS(BALANCE)" >>> >>> > >Here is part of the output: > > 00000955485 1972.55 > 00000971405 114629.25 > 00000987328 45803.12 > 00000048108 0.0002 > 00002006146 54125.35 > >I'm wondering why the record with balance 0.0002 got selected. Can someone >help me out? > >Regards, Marco. > > >--------------------------------- >Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail >to make your dream a reality. >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
