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? The SQL command you're looking for is LIKE. WHERE column LIKE "DAV%" % matches 0 or more characters, _ matches a single character. How you use it depends on how you are implementing your retrieval form. In a related question, does anyone know if you can set querymode to use LIKE instead of =? Thanks, Scott -- ------Scott Morizot-----------tmorizot@infinity.ccsi.com------