re: Searching from forms

> A column in my table is RANK. The data possible in that column is: > PV1, PV2, PFC, SP4, CPL, SGT, SSG, SFC, MSG, 1SG, SGM, and CSM. The column is > defined as a 3 char data element. In a form, how would I select say > all rows with SGT and SSG? I have tried SGT..SSG--that doesn't work (it > includes the SP4s. The above data is in order low - high. > > > Thanks! > > SGT Ray Storer > US Army > Cp Coiner, S. Korea > eapc-amo2@emh7.korea.army.mil try: SGT|SSG from th 4gl reference manual pg 7-41: symbol name datatype pattern ------ ------ -------------- ----------- : range all x:y .. range datetime x..y and interval | or all a|b|c -- regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | |----------------------------------------------------------------------------| | 'connectionLESS IS MORE' -- Data Broker | |----------------------------------------------------------------------------| | Duct tape is like the force. It has a light side, and a dark side, and | | it holds the universe together ... | | -- Carl Zwanzig | +----------------------------------------------------------------------------+