Subject SV: [firebird-support] Re: Problem slow sorting/distinct in Firebird
Author Poul Dige
Sorry for interfering - but I just wanted to say: Brilliant trick, Fabiano :)
I will remember that one!
Regards,
Poul

Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] På vegne af Fabiano

Istead of:

(LCASE(art.Artikelnummer) like '%a4 papier%') or
(LCASE(art.Artikelnr_leverancier) like '%a4 papier%')

Use:

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



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