Not finding a record

>>Subject: Strange behaviour of SQL-Perform >> >>I found something strange in Informix-SQL perform: >> >>Entering "Bruns*" as the only search-criteria in the perform-form of >>our address-table gives the message: >>The are no rows satisfying this condition! >> (Or something similar..) >> >>But entering "*Bruns*" finds a row with the entry "Bruns Minden" in >>the specified column. >> >>Any explanation? >> >> >> Joern. This could be a corrupted index. Could it also be a hidden escape sequence in the record???? Maybe??? So that the B in Bruns is really not the first character in the field. cheryl Red River Army Depot Texarkana, Texas 903-334-3518