Subject Re: Like query From Mervyn Bick <invalid@invalid.invalid> Date Fri, 27 May 2022 17:31:24 +0200 Newsgroups dbase.getting-started On 2022/05/27 13:00, Tom wrote: > MAGIC :) > > I do notice the need to type a leading zero for April dates is no longer > necessary. Saves me some typing. With the "Contains" option, whether April is shown in the date converted to character as 04/ or 4/ the 4 in the search field will find all records for April as well as any records for the 4th, 14th or 24th of any month. With the "Begins with" option you should need the leading 0 to find April records.  I do on my computer but your computer behaves differently so maybe not.  :-) It depends on the size of the table and the number of people on the system but using LIKE to select records, especially with the "Contains" option can be hard on the system.  The SQL engine has to examine every record to determine if it needs to be included in the rowset.  This happens each time a character is added to the search string. Incrementing the search one character at a time can be hard on the network as a new rowset has to be provided as each character is added to the search string. > Tell your wife I will stop bothering you now. She will be pleased. She'll only start complaining I keep getting under her feet. :-( Mervyn.