Subject Re: [firebird-support] Matching regarding primary differences
Author Dimitry Sibiryakov
On 23 Jun 2003 at 12:20, peter_jacobi.rm wrote:

>Any ideas for implementing the 'increment'?

I'd suggest an additional column in table which is filled with
uppercased, unaccented string by triggers (or application). Then you
can use something like SELECT col FROM t WHERE uppered_col STARTING
WITH :pre_uppered_search ORDER BY col. After you get the result set
you may do further filtering on the client.
I suppose your app can make unaccented string from search pattern.

SY, Dimitry Sibiryakov.