Re: Searching from Forms

Alan Popiel writes: |> ->From: EAPC-AMO2@emh7.korea.army.mil |> ->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. |> |> SELECT ... |> WHERE rank IN ( "SGT", "SSG" ) That would work if he was using SQL or 4gl to access the data. Since he is asking how to do it from "a form", I'll assume that SQL is not an option. In that case, try entering SGT|SSG in the form field for RANK. That will return all rows where RANK has either the value "SGT" or "SSG". Dave Kosenko Informix Advanced Services Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney