Re: Looking up a field in an ISQL form... using partial string

Kate Juliff (kcj@netcom.com) wrote: : I have a form where the user can input into one of four fields and then : the relevant rows are retrieved. One is a char(20) field and I want the : user to be able to enter a partial string. e.g. if the user input "DAV" : then all rows where the value in the field began with "DAV" would be : retrieved. Is there any way to do this? And now that I've figured out what group I'm in and actually read the subject [abashed grin], I can give you the answer you're looking for. In a perform screen, the user can enter a * at the end of the string to match everything starting with the characters entered. If you press <CNTL>W while querying, you'll get a help screen of that and a lot of other options. Hope I *finally* helped, Scott -- ------Scott Morizot-----------tmorizot@infinity.ccsi.com------