Hi Schalk, > Can somebody help me with the syntax of EVAL. I want to execute a SELECT > on a file to get all records where (field 16)*0.9 < field(17).
Various ways to do this. Try... SELECT file WITH EVAL "F16 * 0.9 < F17" = 1 where F16 and F17 are field names from the dictionary. The most common mistake is to miss off the = 1 at the end. Remember, this EVAL expression is going to return true or false. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users