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

>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? Kate, in Isql forms you can use wild cards. If you want to select all records stating with DAV you can enter DAV* and you will get all the records. Regards ----------------------------------------------------------------- Databaseadministrator Poul Pedersen Kuwait Petroleum (Danmark) A/S Hummeltoftevej 49 Mail: pp@q8.dk 2830 Virum Voice: +45 45 98 45 94 Denmark Fax: +45 45 83 16 95 -----------------------------------------------------------------