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? Whoops! You can also use MATCHES with * and ? as the wildcards. And ignore my question in the preceding post, everyone. I lost track of what newsgroup I was reading. That was a Powerbuilder question. Sorry, Scott -- ------Scott Morizot-----------tmorizot@infinity.ccsi.com------