> 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 ...
Not true! Selection uses external format data. Where a field with a conversion code is compared with a constant, the constant is converted to internal form prior to the comparison. The LIKE operator works the other way around and converts the data to its external form as it couldn't work any other way. I suspect that the offending record actually has some other problem with the value stored in this field and the conversion is not happening. Try using LIST.ITEM or just editing the record to look at this field. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
