>David A. Green <[EMAIL PROTECTED]> wrote on 09/11/2006 10:50:40 AM: > > Also try using BETWEEN like this: > :SELECT WAREHOUSE WITH PRIM.BIN.NUM BETWEEN "131" "139" > >Also a problem in ECLTYPE P - the specified strings are NOT included with >the BETWEEN keyword.
Not if you lowercase your command: select WAREHOUSE WITH PRIM.BIN.NUM LIKE "3N" AND PRIM.BIN.NUM BETWEEN "131" "139" Thanks, David A. Green DAG Consulting --Tom Pellitieri Century Equipment ------- 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/
