Searching from Forms

> Date: Tue, 15 Feb 94 21:31:17 KST (2131Z) > From: EAPC-AMO2@emh7.korea.army.mil > To: informix-list@rmy.emory.edu > Subject: 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 What you want is to use [SGT|SSG], which is the OR clause for a form. BTW, The .. won't work on any but a DATETIME or INTERVAL field, did you mean the : as a range specifier? This is in the Informix SQL Reference Manual, v4.00 pg 4-36 under Query Operator Syntax. Personal note: Once in a previous life I was an SGT in charge of database design and system admin for the Special Operations Command on Ft. Bragg, NC. Do you know anyone who was there between 1983..1987? Also, there are some civilian contractors from a company called ITP in Korea (somewhere) that we used to work with (Julie Kent, John Poirier), they have considerable Informix experience. Have fun, Clem __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | | Reynolds Metals Co. "Climb High, Cave Deep!" | | Alloys Plant (MS #59) | | 3509 East 2nd St Internet: cwa@leia.rmc.com | | Muscle Shoals, Al Telephone: (205) 386-6783 | | USA 35661-1256 Facsimile: (205) 386-6831 | |________________________________________________________________|