I’m using a database of Census records, that has been converted from MS “Works,” to Libre “Base” format, but find that when searching on a specific field, if there is additional information in that field, “Base” does not find all the entries - i.e. I can search for “Peter” in a field and “Base” finds all the “Peter’s,” but doesn’t find 3 others that are in the “Works” database, that have alternative spellings - i.e. “Peter/Petter.” How can I use a wildcard search please, that would find all entries? (I’ve searched on a 2nd field for “/” and also “Peter/” which brings up no results at all.) Any assistance would be much appreciated please.
The percent char has in SQL the role of the * to search for arbitrary characters, so try Peter%
.
Actually this may depend also on the database and settings…
“Where” are you searching? In a query? Table-View? On a form?
Hi, Thanks for the suggestion - yes I had tried both the * and % possibilities, which return no results at all. I’m thinking perhaps the problem could be due to the conversion process from “Works” to “Base,” which may be insurmountable. The database has just under 2000 entries, with 17 fields, so re-inputting the data is a “No-no” and I can’t “copy and paste” the information, as it all ends up in the first field - annoying! Thanks again for your fast response.