Re: Searching from Forms

Posted in 1994

Alan Popiel — 15 Feb 1994 11:08:07 -0500 — source: Informix-list mailing list archive (1991-1998)

->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 SELECT ... WHERE rank IN ( "SGT", "SSG" ) Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\