Yes, if you have these data: ANIMALS table ANIMAL_TYPE CICA CSIGA DARÁZS ZEBRA ZSIRÁF
Grammatically the correct solution: select animal_type from animals where animal_type starting with 'C'; CICA select animal_type from animals where animal_type starting with 'CS'; CSIGA select animal_type from animals where animal_type like '%Z%'; ZEBRA select animal_type from animals where animal_type like '%ZS%'; DARÁZS ZSIRÁF However, I am not sure whether it is not a better result for the average user today, (e.g. in a quick search) if all appear after typing C... CICA CSIGA or Z.... DARÁZS ZEBRA ZSIRÁF And on that, it's even more complicated .... For example, in the word of "IGAZSÁG", ZS is not a letter, but here two, a Z and an S. select word from words where word like '%S%'; IGAZSÁG select word from words where word like '%Z%'; IGAZSÁG select word from words where word like '%ZS%'; null is grammatically the correct answer.... (But I have no doubt that no one would expect this from a non-grammar program as a result ...) Gábor, am I correct? András -----Original Message----- From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] Sent: Saturday, November 6, 2021 11:54 AM To: For discussion among Firebird Developers <firebird-devel@lists.sourceforge.net> Subject: Re: [Firebird-devel] ODP: RFC: Fix for issue 6915 Gabor Boros wrote 05.11.2021 16:39: > 2021.11.05. 12:36 keltezéssel, Pavel Cisar írta: >> However, the Czech language defines only one contraction (CH), but >> there are other languages that have many such as Hungarian. > > > Yes: cs, dz, gy, ly, ny, sz, ty, zs and dzs. Sorry. :-) Is it ok from the language point of view not to find them by first character? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
