Subject RES: [firebird-support] Re: Problem slow sorting/distinct in Firebird
Author Fabiano
Thanks Poul!

The unique problem with this approach is when you have a null value in one
of these columns it will not work correctly.

So, the 'correct' way is use coalesce do convert null value in empty string:

(LCASE(coalesce(art.Artikelnummer , '')||
coalesce(art.Artikelnr_leverancier, '')) like '%a4 papier%')

Another tip is create a calculated column in the table with the above
statement - with the name find_name.

So, you can easily write a simple SQL like:

Select * from some_table where find_name like '%a4 papier%'

[Non-text portions of this message have been removed]